COMBINE multiple TABLES from different files in different file paths (Power Query) in Excel

[LeighMacKay7]

Hi,

I am looking at trying to COMBINE multiple TABLES from different files, in different file paths (Power Query) in Excel

All 6 of my tables have identical headers and are in the same order. It's just going to different source datasets and pulling them back in, which I am struggling with.
Does anybody have a video or any guidance documentation, that would help, please.

Thanks in advance
Leigh

 

[MCLIFTO8]

You pull them all in normally as separate queries and then make a new query as an 'append' query. Select 3 or more tables and just add them all together in the dialog box.

 

[LeighMacKay7]

You pull them all in normally as separate queries and then make a new query as an 'append' query. Select 3 or more tables and just add them all together in the dialog box.

Thank you for your reply.
What you are saying here is correct. But I didn't explain myself very well in my original message.
I have now managed to fix it. But I appreciate your response.