Thread: Sort multiple worksheets at the same time

I currently have a workbook where I have one worksheet where I enter some records and the first 5 columns with info about the records are copied to 3 other worksheets. On the 3 other worksheets I have areas to add more information about the records and some of these values are returned to the main worksheet. The formulas for this work good until I have to sort the information on the main worksheet. When I do that, the information on the other pages does not sort and the information that was entered on the other worksheets is still in their original rows now corresponding to incorrect records.

I am wondering if there is a way to be able to sort information on multiple worksheets at exactly the same time as to prevent the information entered from getting moved to other records.

Attached is an example of the workbook I am working on only with many more records than this. I have left it unsorted so anyone can see what the problem is when one page is sorted. I was thinking a button with a macro to sort it would work but it has been a long time since I've done any coding so I would not know how to do it.