How can I append tables from a different workbook into one worksheet?

I have a pallet-level inventory workbook. Each sheet has a pallet manifest in table form (table & sheet name: Pallet_0001, Pallet_0002, etc.). I'm looking to create a new workbook containing one sheet: a combined inventory of all the pallets. I want to lock that workbook so that all changes have to be done on the pallet-level inventory workbook. I've tried using Power Query (which I'm not great with), but I always get one sheet with the combined inventory, and individual pallet inventory sheets behind it. I can't delete the individuals because Excel tells me they're connected to the first, merged inventory, worksheet.

I said in new post not new thread
this is duplicate