Linked multiple cells, arrays and precedent cells re-sorting

[Eusr]

I have a worksheet with 4 sheets, and a 5th sheet with all the data amalgamated. It's all text formatted.
Each of the first 4 sheets is an array of cells linked to a block of cells in Sheet 5. Sheet 5 is all precedent cells.
Now that I have linked all the cells so that any changes to Sheet 5 will be reflected in the relevant sheets 1, 2, 3 or 4, I want to change the order of the cells in the precedent sheet.
So far, precedent sheet 5 has been sorted in blocks of categories (one of four designations in a certain column), each of which has its own dependent sheet 1,2,3 or 4.

I'd now like sheet 5 to be re-sorted according to criteria in a different column or columns.

Can I change the locations of the linked-to cells in precedent Sheet 5 and have them remain linked to/connected with unmoving locations in the dependent sheets, yet new values entered in the precedent sheet still update the dependent sheets?

Here's how I linked the cells between the sheets:
select dependent cell array
=Sheet5!A1.R100
SHIFT+CTRL+ENTER

[JeteMc]

Hello Eusr and Welcome to Excel Forum.
It may help someone better respond to your request if we could see a sample .xlsx file, instructions are in the banner at the top of the page.
Let us know if you have any questions.