VBA code for sorting data on multiple sheets

Hi,
I'll try to explain my problem as good as possible.
I work with 1 'main page' in excel and several help pages.
On the main page I can enter different names in cell A1. I get in cel B1, C1 and D1 values who are linked with that name.
Those 3 values are the base for a lot of formulas in the help pages. All this works perfectly. But:
I need a VBA code that will do the following: I want to sort the data (column A, from A5:A730) in the help pages automaticly the moment I change a name in cell A1 on my main page. (Without going to the help pages) Sorting from high to low.
The data in those help pages is big. I got 100 columns and 730 rows on each page. (normally 4096 rows but I skipped a lot of them) And I have 9 pages... Only the first 5 columns must be sorted. The rest will follow automaticly because that data depends on those first 5 columns.

So, who can help me with this? I tried a lot of things but I didn't succeed.

Administrative Note:

Welcome to the forum.

Please attach a sample workbook.

Is your forum profile showing the Excel PRODUCT that you need this to work for? There is no version known as 7.1.

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

That's still not enough, sorry. Which PRODUCT is it? Is it 365? And is it for Mac? All of these things need to be in your profile.

You have not attached a sample workbook.

OK - we are getting there, but you didn't add 365 to your profile. And you still haven't provided a sample workbook - instructions are in the yellow banner at the top of the page.

Please see here:

https://learn.microsoft.com/en-us/of...office-for-mac

Kindly add 365 to your profile. Thank you.