I have a workbook with 5 sheets in it. Each sheet has the same name in the
first column however all other columns in each sheet are different.

There are around 300+ rows in each sheet. I would like to be able to sort
the first sheet and it in turn sorts all other sheets the same way. That way
if someone is looking at row 56 on the first sheet row 56 would be the same
for all other sheets.

In a perfect world if I sorted any of the sheets it orders all other sheets
in the same way. Basically if I were to put all the sheets into one huge
sheet and be able to sort anyway I want. The issue is spreading that across
multiple sheets.

Hope I explained that well enough

Thanks,
Fred