How to input data regardless of the sheet name? / file name

[AndyHH]

Hi Community!

I want to input data in excel but sometimes the sheet name is different, how do i input the files regardless of the name of the sheet?

/

Other than that, another question is if i want to input sheets name that starts with the same logic like aa122, aa123, aa124, how do i make it happen?

/

And for the last question, when i input files that maybe the excel itself sometime will also named wrong, do i have to rename it manually myself or there's any way to read those files?(What i learned is maybe can use directory tool but i'm not sure if it is applicable). 

Many thanks if you have any feedback for these!!

[AndyHH]

hi @Matt_D. Could you send your file to me for testing ? Thanks a lot.