Compile data from multiple sheets into one summary sheet

with Power Query

is that what you want?
unfortunately you didn't say what you want to sum but you can do that very easy yourself with Pivot or just adding a Total Row

btw. do not use empty rows in tables as it unnecessarily increases the size of the file and slows down the performance of excel

Originally Posted by scorpain

Perfect is that.
Is there a way to get power query without having to download? This is a work laptop so I can't download it ¬_¬

sorry but I really don't understand what do you want to download?
XL365 has Power Query build-in you don't need to download anything

but if this is so perfect and

---

if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful)
and then mark the thread as SOLVED (top above your first post - Thread Tools)