Sorting issue when using IF statements to pull through data

So I've created a fairly complicated sheet whereby I have a mixture of IF Statements and LookUps that pull data from an initial sheet and puts them in different sheets depending on what certain rows say (I really hope that makes sense!).

The different sheets dictate actions that need to be taken to a record, and once done I put "yes" in the relevant cell.

However I need to be able to sort every sheet, and when sorting the primary sheet, the "yes"'s on the other sheets don't sort with it.

Is there anything I can do to fix this?

Hi Marvin

I realised that my enitre sheet was entirely flawed, so I fixed my issue by using a copy and paste as values only Macro.

This worked really well, however does not update automatically, and quite often lags my workbook.

I tried fixing the update issue by using an auto run Macro VBA in the code of each sheet. However the entire workbook weirds out every time I edit a cell, and after 2 minutes of the either crashes or works, any idea how I can fix this?

I will upload my spreadsheet now.

Thanks for your help.

Right I think I have uploaded it...

Focus on the "Starters & Leavers Input" and "Starters and Leavers" tabs.

So "Starters and Leavers Input" is where I initially add the data, then the Macro copy and pastes as values only on the "Starters and Leavers" tab.

Try inputting a line on the Input sheet to see the weird thing it does.