Nov 04 2021 09:12 AM
Nov 04 2021 09:58 AM - edited Nov 04 2021 09:59 AM
Here excel - Copying worksheets from multiple workbooks into current workbook - Stack Overflow are some scripts for that. Not sure, if you are not familiar with VBA, entire cycle will be faster than manual copying of sheets (I guess it could take about an hour), nonetheless.
Nov 04 2021 10:27 AM
Nov 04 2021 10:36 AM
To my knowledge no such. Programming or from right click menu on tab name.