Keep data in sheet 6 if data entry sheets 1-4 change

Hi,

I have a workbook which contains 6 worksheets, The first 4 sheets are data sheets, which is cut/paste from an external source. Sheet 5 contains the information I require from these 4 data sheets going across each row/column. When I update the 4 data sheets the information auto changes on sheet 5 so for example sheet 5 a1 =sheet4,b2. Sheet 6 has a similar layout but I want the data that is inputted to stay the same when I update the other 4 sheets and after update, I require the data to move across 1 column.

Is this possible??

If you require more information or a dummy workbook please ask, I've spent 14 hours googling and checking various forums for the answer with no luck.

Thanks