VBA for copy/paste multiple data points from multiple worksheets to one master file in various tabs

[FinMacro1]

Hello all!

Here is my macro question. I have multiple Divisions that are sending me all their Entity Data. I will be saving each Division in it's own folder. I would like to make one master file for each Division.

There are three sections of data in every worksheet I want all on tab '7.Data'

Section1: Runs B1 to B29. I would like that pasted in the master moving right across the spreadsheet on tab '3.questionnaire'

Section2: Runs C1-J42 I would like that pasted in the master stacking (moving down the spreadsheet-no spaces between entities) on tab '4.Cash Flow'

Section3 C43-N62 I would like that pasted in the master stacking (moving down the spreadsheet) on tab '5.Balance Sheet'

Close the spreadsheet, 'No' to saving clipboard data, and move to the next file, stopping at the end. If we can add if no tab "7.Data" then close, move to the next.

I would like to use this data on all Divisions, where the file will have the same three tabs. The name of the file will be Division name Master - So every master file will have 'master in it'

Any help is appreciated. One Division has 100+ entities and I cannot manually Copy/paste that - I had a hard enough time with one Division that had 26 files.

Thank you so much for taking the time to read my post!
FinMacro1