Hi BobBridges,
That's actually a really great question in response. I'd kind of decided that if I'm unable to make this work reliably, that I would in fact put all the data on one sheet. The reasons are:
1) The sheets are for different purposes, and would be used in different contexts.
2) The data that I'm hoping to put into column B of sheet2 is going to be long(ish) strings of text, preferably with line breaks. If it has to go into sheet1, it'll make the whole sheet very bulky and less readable than it currently is.

Your suggestion "to start with a master sheet having all the data in one place and then figure out how to display selected columns elsewhere" sounds likely to be a good way forward. It'll solve reason (1) above, but can you think of how to solve reason (2) that way?

Thanks in advance.