[USER="299865"]AliGW[/USER] Apologies. I didn't mean to sound rude or disrespectful. And I do appreciate your answer, so thank you.
Yes, your method does work. I tried it with a new workbook with new tables.
What I meant was your method somehow doesn't work on the workbook that I'm working on - which is weird.
When I get data from the file, the tables are listed as the sheet. So if I have 3 tables in that sheet, it's being read as 1 big table starting from cell A1 (my table starts from A5).
Example:
I have 5 sheets named after Client 1, Client 2, Client 3, and so on - where table Client 1 always start at cell A5.
Each sheet has 3 tables with these tables names: Client1_Pot, Client1_Vase, Client1_Mirror - where Client1_Vase is below Client1_Pot, and Client1_Mirror is below Client1_Vase.
When I tried applying your method, (Get Data > From File ...), I can't select my tables (Client1_Pot, Client1_Vase, Client1_Mirror, etc), because all the tables are being read as the sheet's name: Client 1, Client 2, Client 3, and so on. And I preview the "table", it shows: Client1_Pot, Client1_Vase, Client1_Mirror, merged into one big table starting from cell A1. And that's my issue.
I truly apologize if my explanation isn't clear enough. I can't attach the real file for it is a matter of confidential data nor can I attach a new file with it since my issue doesn't apply on new workbook.
So, if there's any other solution that you can suggest then I'll be truly grateful. If not, then thank you for taking the time to even respond in the first place.
Have a great day.