Creating a updating master list from multiple tables

Hello everyone!

So here is the deal: the wife and I are going to England for 18 days. For reasons that I don’t even know, I am creating a Excel spreadsheet that we will use to plan each day. The spreadsheet is attached. Basically there are many different worksheets for each of the days. For each day, there is a column for the day (to be hidden later), activity, cost, and comments.

Here is my desired result: On a separate “Costs” worksheet, I want there to be a master table that updates each time a new activity for that day is added in their respective tables. An added bonus would be that this master lists for “Costs” would not include items that have a cost of $0. (Of note, the data for the individual days can either be in a table or a range; it doesn’t matter to me. However, I would like the master to be a table for sorting purposes)

The spreadsheet I have created so far is attached.

At this point, I have tried multiple ideas (consolidation, pivot tables, msquery) and I am pretty much at my wit’s end. I figured at this point it really isn’t that big of a deal to have but I would like to have it in there if I can. As such, I am reaching out to humans that can give help for my specific situation.

I haven’t got in to the realm of macros with this so far, so I hope this is in the right subforum. If it isn’t and there is a better solution, feel free to move.

Thanks in advance!