My problem is difficult to explain, so I have attached the actual spreadsheet so that you can see what I am talking about.
My Spreadsheet is designed to keep a tally of staff and their Recreation leave entitlements and also to keep record of what leave they plan to take each month. This doubles as a roster system so that at a glance, managers can see who has requested leave in a particular month in a location. Thus ensuring adequate staffing in a location at any one time.
In my spreadsheet I have a main sheet (accruals) with links to sheets for each month of the year. (only 3 months at this stage) There are also links in each monthly worksheet back to the main sheet (Accruals).
The trouble I have is that when I sort the "Accruals" Worksheet by Location. The sort works for the linked cells, but the cells for each day of the month dont move and thus the data is in accurate.
What am I doing wrong?