is it possible that when you freeze panes, the left part frozen is the part
from let's say "worksheet 1), but then the left part is from any worksheet
you click?

i'm doing a summary which involves categories, so i had to make different
worksheets for it.  however, the items is always from the same worksheet 1.  
if i put on the same items on each worksheet, and next time i update, either
i update every item on every worksheet or i forget to update them and just
update worksheet 1....

any help on this? willing to do macros and others.... thanks a lot in advance