Hi, hope I explain this clearly and that there's a simple solution, plus thanks for any help in advance.

I've split a workbook into 8 sheets. Sheet one has the initial info, much of which is replicated throughout all other 7 sheets by way of " ='Check Sheet'!E46 " which works great.

Each sheet though has unique info (the reason for the number of sheets) which may also be linked in the same way to another cell on another worksheet (I'm using this method to reduce the amount of time spent repeat typing of same data).

Then I receive data that needs to be entered but its eg "date id ref" is not in order so the sheet needs to then be sorted after entering so as to be in the order I need. When I sort the 1st sheet, due I think to the other sheets link system, all the other sheets info is then out of sync and doesn't sort all colums correctly. It's as though say the data in column 3 of sheet two that sheet three is linking to, is locked and therefore does not keep with the row data it was entered with. Thus becomes out of sync.

If I try to insert a new row for the data that puts it in the right order on the 1st sheet without needing to sort, again, the other sheets become out of sync when I sort, as at least one column seems locked and unable to move the data with the row data it should be with.

My formula/macro/vba understanding is very basic (and less). So how can I get any changes on the first sheet to auto update all the other sheets with regards the positioning of the row data? Using ='Check Sheet'!E46 where required updates the data from cell to cell - worksheet to worksheet very well for me.

I must say that when I began designing this workbook, the layout was not what I wanted, but believe through reports and pivot tables (once mastered) will provide the info I'm being asked to produce. My problem (besides teaching & learning myself how to get more from Excel) is creating something that with my limited knowledge will work now and allow the readers of the data to get what they need (the readers being totally lacking in computer/software skills) knowing that the data I receive can arrive late for inclusion but must go in a specific order..

Thks again, Liam