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?