Append to a query in Power Pivot

Good evening,

I thank you in advance for your help.

I'm attempting to start using Power Pivot. The data I have is on roughly 30 spreadsheets. The information is normalized in terms of column headers and format. I began to load it and it occurred to me that this whole thing would very cumbersome to deal with if I had 30 sheets (and growing) that I was attempting to run pivots/reports from. Is there a way I can just load one sheet and then append data to it the same way I would in Access? I spend a good deal of time looking for the answer in various places but didn't find anything. I didn't even find anything that semi answered the question.

Any help would be great appreciated. I'd happily do more research if someone could even point in me in the right direction. It seems to me that there would be a way to do this but I can't seem to find it.

Thank you

Look at Power Query and Appending Worksheets, then your appended query is linked to PP and will update when the refreshed Icon is clicked.

Administrative Note:

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

Thanks. I replied to your other thread - not sure you’ve seen it.

It does work - I do it all the time. Would have been nice if you’d acknowledged the suggestion, though.