Macro for Pasting Formula/Formatting across multiple named worksheets

[RobMyThoughts]

Hi guys,

I've started a new role that requires me to fix the mess my predecessor created.

My current assignment is to fix the formulas and formatting for over a thousand worksheets, spread across multiple workbooks.

Each workbook represents a country e.g. 'England' and each worksheet in said workbook represents a number e.g. '001'. There isn't much consistency as to how many sheets each workbook has but none exceed 50.

So, my problem is that I fixed the formulas and formatting for the '001' worksheet, in the 'England' workbook but now I have to apply the same alterations to every other worksheet in all workbooks.

Then I have to do the exact same to workbooks named 'Germany', 'France' etc

I should point out that each worksheet has numerous cases of text i.e. country specific data, that mustn't be altered - which prevents me from simply pasting the required number of tabs.

I have a basic understanding of how to create and use macros but I can't currently think of a time-effective means to achieve this mundane task.

I really appreciate any input

Robmythoughts

 

[RobMyThoughts]

I can't seem to edit my original post but I realise I didn't write the post well.

Basically, I need a macro that copies all formulas from the active sheet and pastes them onto all other sheets in the workbook.