Help with Macro to move worksheet to new workbook

[NFCLima]

Hello, I have over 300 workbooks that contain a sheet that I need to extract to a new empty workbook. The name of the sheet is the same in all 300 workbooks and I'm not quite sure were to start with this. Also there are several other sheets within the 300 workbooks so the location of the sheet I need to extract is not always in the same location from the right or left but the name is constant.

Thanks in advance for your help...

 

[PHV]

Tip: the 4th sheet named Sheet4 may be referenced either like this:
ActiveWorkbook.Worksheets(4)
or like that:
ActiveWorkbook.Worksheets("Sheet4")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886