Hi All,

I need some help copying and overwriting a tab from A workbook to MANY workbooks. For example, I have workbook 'Products Master' and in it I have a tab called 'Instructions'.

I want to copy the tab/sheet 'Instructions' onto the following workbooks and replace its existing 'Instructions' tab with the new one:

- 'Product 1'
- 'Product 2'
- 'Product 3'
- 'Product 4'
- 'Product 5'
- 'Product 6'

I have 150+ products workbooks but lets use 6 as an example.

is there a quicker way to do this using VBA or Macros rather than opening each and every workbook and copying and pasting so many times?

Thanks Guys.