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