Compile Line Items from Multiple Tables to One Table

I am currently working on a project that I am building a workbook with multiple sheets. Each sheet ties to an individual manager. They input their financial call points which then roll up to the president of the business. This is all working fine. I have now been asked to put a table in each sheet for each manager to provide opprotunities and risk to their business along with notes. The president would then like all of their notes from each sheet to roll over into a table on his sheet so that he does not have to look through the workbook. How do I get this information to pull over cleanly?