Yes, this functionality is known as a Worksheet Action. Unfortunately I am unable to access your workbook, as I am currently using Tableau 8.3 and it looks like you're using Tableau 9 (Tableau lacks backwards-compatibility), but I've cobbled up an example using one of the Tableau sample workbooks (see attached).
I built this by going to Worksheet > Actions > Add Action > Selected Fields > Source: Sheet 1 > Target: Sheet 2 > Selected Fields: Year(Order Date).
Thanks so much for the reply Eric. Yes, I was trying the actions feature but for some reason it was not working properly. I think it may be because my source sheet does not display the year dimension, but the target sheet does. My source sheet just has a filter for the year and then the title on the sheet displays the year based upon the filter selected. The measures in the table of the source sheet change when the date filter is changed but the table does not actually show all of the years (other than in the title as noted above). Sorry, if that's confusing. I will keep playing around with the actions and see if maybe a duplicate sheet and tricking Tableau may work. Thanks again!
Michael, long time since this thread was alive. Did you ever figure this out? I am trying to use a highlight action to highlight fields in my target sheet that are not in my source sheet, nor do I want them in the source.
Let me refresh my memory on this one. I do not recall ever finding a solution for this but I am sure there is a way and I have a little more Tableau knowledge now than i did 2 years ago. I'll get back to you on Monday on this (hopefully with a solution).
Is it possible to send me a sample file? Thanks