I have a problem with Excel

I have a number of worksheets which have a common first column but different
purposes in other columns/sheets

I would like to be able to lock the worksheets together so I can scroll on
one sheet and then switch to the next sheet which will be at the same row as
the first

This would save me so much hassle can anyone tell me if this is possible??

Thank you
--
Hunting for answers