Macro to combine same-named sheets from multiple files

Hi All,

I have 30 files in one folder, each of these files has 6 tabs identically named: dog, cat, bird, fish, fly, ape. I wish to combine only the ‘cat’ sheet from all 30 files into a single file, with the sheets renamed to cat1, cat2, cat3,…cat30 (or some sequential naming order)

Thank you in advance

Put this macro in a new spreadsheet.
Save it in the folder
open it
Stand Back

Please Login or Register  to view this content.

o..m..G!

My hero! This is fantastic! I've tried 20 macros today and none worked - your is flawless - cats everywhere! BIG THANKS

o..m..G!

My hero! This is fantastic! I've tried 20 macros today and none worked - your is flawless - cats everywhere! BIG THANKS