How to copy a sheet from one workbook as a sheet onto multiple workbooks

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.

This may take awhile, but maybe:

Sub hld142()
Dim i As Long
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
For i = 1 To 150
Workbooks.Open FileName:="D:\common\YOUR PATH\Product " & i & ".xls"
    Workbooks("Product " & i & ".xls").Sheets("Instruction").Cells.Value = Workbooks("Product Master.xls").Sheets("Instruction").Cells.Value
Workbooks("Product " & i & ".xls").Close True
Next i
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub

Note: Change .xls in code to .xlsx