Thanks Tracy, but this still assumes I only want one data source per workbook....
I tried doing a bookmark, but what happened was when I changed the data connection in the new workbook, it changed all the other worksheets I made that used the same data source as the bookmark.
the workbook has 4 worksheets from each of 4 data sources. Each data source is formated the same, with the same columns. so when I make a worksheet I like with one source, and I copy it and try to change the source for that one worksheet, I end up changing all the worksheets to the new source (using replace data source).
when I did the bookmark, it kept the first source because the workbook itself already had all the data sources.
book marks would have worked if the workbook didn't already have that second data source.
maybe I didin't explain it right too.
The original workbook has both data sources, and when I make one worksheet from datasource 1, how can I copy that sheet and point that new sheet to data source 2 without changing the other worksheets for either datasource.
I guess I could do a union query, but tableau doesn't connect to union queries.