Copy text and formatting to all sheets in workbook.

[michaeldaniel25]

Hello,

I have what I'm sure if an easy problem, but I can't find a way to do it looking through the threads.

I need to find a way to copy text and formatting from one sheet to all other sheets in the workbook.


The tab called Master is what I'd like the other sheets to look like.
the top and bottom section highlighted in yellow are what I need to copy to all other sheets. In my example, I only have two (supervisor 1 and 2), but I'll have many more.

A few notes:
- i need to do this on approx 70 different workbooks, so the name of sheets and number of sheets will vary for each workbook.
- the number of supervisors on each sheet will change. Ideally, I'd like to copy the text from the bottom of the Master sheet, and the cells colors, to the bottom of the charts on the supervisor tabs, 3 rows beneath the table, but i'm happy with always inserting it on, say, row 15.

Please let me know your ideas. I have to do this for 70 workbooks all saved in the same folder, if theres a way to speed that up I'm very appreciative.

Thanks,