Sample.xlsmHey, thanks for getting back to me, i should have attached an example of what i'm doing to be clear....

In the attached file, there are 3 sheets, i want each sheet to be a 'tab' in a table with a common / unique identifying key......

So, if i scroll to line 300 on teh first tab, i'll be on row 300 when i switch tabs......