synchronize worksheet in a workbook
 

HI,

I have a excel workbook and it will do a qeury on MS acess
table and the data will be loaded into several worksheet

these worksheet has same structure, just the data is
different. i wonder if i can synchronize the views for
these worksheet, that is, when i am viewing on Item Z in
group A in sheet1, i want to go to the same Item in the
same group in sheet 2 as well.

May i know how can i do this ?