If your sorting on the first column in each sheet individually and the first
column of each sheet all have the same list of names in the first column as
there are in the first sheet, then the rows should match. Just sort each
sheet individually on the first column.

--
Regards,
Tom Ogilvy

"FHKBaker" wrote in message
...
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