Power Query question (never used before!)

[Jyggalag]

Hi all,

I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query.

I want to import data into this pivot table (not using power query below):

I have the source data saved here:

So questionnaire data file 1 is week 1, data file 2 is week 2 and so on.

The data itself looks like this (with the sheet being named week1 in data file 1 and week2 in data file 2):



What I would like is to have a conclusion that looks like this:

But I would like to have it where the data is inserted automatically from Power Query, for example every time you press refresh and it then creates these new columns of data for the next week and so on.

Does anybody have any idea how I can do this? For now I seem to only be able to connect to one file when I choose "Folder" as my data source and I have to build the pivot table from scratch then. This seems to work fine if I make changes in that one data file and then press refresh, but I have absolutely no idea how to do it with multiple files.

If I could get some assistance here, it would truly save my day, week and probably month to be honest! Been spinning my head around this issue and any assistance at all would be greatly appreciated

Kind regards,
Jyggalag

 

[AlanY]

a few YT videos might worth a look

 

[RoryA]

This appears to be exactly the same as your other question, so I'm locking this.