Vba macro help on copying specific worksheeets in a master workbook

Welcome to the forum
Amend to suit
Assumes all files have extension ".xlsx"
Only filename (NOT Extension) required in array
fPath needs to be the full folder path followed by "\"

In standard module:

Please Login or Register  to view this content.

Note
Variable wb is not dimensioned with a variable type - used as variant, string & workbook