Copying a worksheet with tables and cross-joins - possible to do it?

[Reboshua]

Apologies in advance if I don't articulate this clearly. I'm not sure I understand myself exactly how to say describe it.

I have 3 tables, one in each column (A-C below)

I am using Power Query to do a cross join (or cartesian join - not sure the right name) and the output of that cross-join is displayed two columns over. (F-H)

I've set this up exactly as I want it and it works great. If I change the data in the tables in columns B, C, or D, and then hit refresh, the cross join will update with the new data properly populated. WONDERFUL!

BUT, if I make a copy of this worksheet and rename it, this copied worksheet does not behave the same way. If I change the data in the 3 tables on the second, copied sheet, and hit refresh, it does NOT update and populate properly.

Two questions:
- why does the first sheet update the cross-join properly when I change the values in the 3 tables, but this does not happen on the copied sheet?
- I need to make 50 more of these sheets - how can I mass copy to create them all but have each sheet be its own unique set of tables and cross joins?

Thanks!




Excel 2016 (Windows) 64 bit

Food1	Food2	Food3		Food1	Food2	Food3
Fish	Dairy	Fruit		Fish	Dairy	Fruit
Cod	Cheese	Apple		Fish	Dairy	Apple
	Milk			Fish	Cheese	Fruit
				Fish	Cheese	Apple
				Fish	Milk	Fruit
				Fish	Milk	Apple
				Cod	Dairy	Fruit
				Cod	Dairy	Apple
				Cod	Cheese	Fruit
				Cod	Cheese	Apple
				Cod	Milk	Fruit
				Cod	Milk	Apple

Sheet: Sheet1