It didn't work for me - was I supposed to dimension something ? I
was wondering why you have workbooks instead of worksheets - maybe I
didn't explain - I only have one workbook.

Say its called USA.xls - and I have 50 tabs with USA_Summary the
first tab on the left - the second tab is AK, the third is AL the
fourth is AZ, and so on - If I'm on TX , and I copy and paste to
USA_Summary tab, I want to be able to go back  to TX.

Sorry I wasn't more clear.