I tried to adapt Ron de Bruin's code in Copy_Folder(), but I fumbled.
Here is my pseudo-Code :

Prompt for SourceFolder path
Prompt for DestinationFolder Path

If DestinationFolder Does not exist, Create it

For Each workbook in SourceFolder

Copy worksheet(2) values & formats only 'Sheet 2 only, No
formulas, Calculations or Filtering
to DestinationFolder, same original SourceWorkbook.name
Next Workbook

Syntax wise, How do I switch back & forth in my loop from the
SourceFolder Workbooks.Sheets(2) to the DestinationFolder ?

Thank you for your help,

Wayne