New to macro's...have information on several tabs that i'd like pulled into one sheet

[karryan]

Hello,

I run an Intake and Onboarding program that spans nationally. The attached is a sample of the Roster that my managers update weekly and it's housed on a sharepoint. Each Manager has their own Tab to update. I am currently spending too much time going in and creating multiple pivot tables to collect all the data from columsn A through Q and trying to find a way to have all the information collected into a separate workbook or atleast a separate tab. I will be moving this file onto a shared network in the future so that linking will work but interim is there a macro or formula that could collect this weekly or as requested into one sheet/book? There will be a total of 8 tabs with different names that i'd like this pulled from.

any help is appreciated as I haven't done a macro in years and so far searching online tutorials hasn't helped me at all.

Sample Attached:

Thank you all,
Karen