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
[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#ED7D31]Food1[/td][td=bgcolor:#4472C4]Food2[/td][td]Food3[/td][td][/td][td=bgcolor:#70AD47]Food1[/td][td=bgcolor:#70AD47]Food2[/td][td=bgcolor:#70AD47]Food3[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#FCE4D6]Fish[/td][td=bgcolor:#D9E1F2]Dairy[/td][td=bgcolor:#E2EFDA]Fruit[/td][td][/td][td=bgcolor:#E2EFDA]Fish[/td][td=bgcolor:#E2EFDA]Dairy[/td][td=bgcolor:#E2EFDA]Fruit[/td][/tr]


[tr=bgcolor:#FFFFFF][td]Cod[/td][td]Cheese[/td][td]Apple[/td][td][/td][td]Fish[/td][td]Dairy[/td][td]Apple[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td=bgcolor:#D9E1F2]Milk[/td][td][/td][td][/td][td=bgcolor:#E2EFDA]Fish[/td][td=bgcolor:#E2EFDA]Cheese[/td][td=bgcolor:#E2EFDA]Fruit[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td]Fish[/td][td]Cheese[/td][td]Apple[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]Fish[/td][td=bgcolor:#E2EFDA]Milk[/td][td=bgcolor:#E2EFDA]Fruit[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td]Fish[/td][td]Milk[/td][td]Apple[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]Cod[/td][td=bgcolor:#E2EFDA]Dairy[/td][td=bgcolor:#E2EFDA]Fruit[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td]Cod[/td][td]Dairy[/td][td]Apple[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]Cod[/td][td=bgcolor:#E2EFDA]Cheese[/td][td=bgcolor:#E2EFDA]Fruit[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td]Cod[/td][td]Cheese[/td][td]Apple[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]Cod[/td][td=bgcolor:#E2EFDA]Milk[/td][td=bgcolor:#E2EFDA]Fruit[/td][/tr]


[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td]Cod[/td][td]Milk[/td][td]Apple[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]