Use Most Recent Data Input On Multiple Sheets?

I am building a shared workbook that will have the same data on multiple worksheets.

The problem is that users are going to be entering updates to that data on individual sheets, not going thru and updating each sheet.

Also, some of the updates will be themselves updated as the day goes on.

What I need is for the workbook to only use the most recent data/update on all of the sheets.

Example: Sheet1 will have all of the info sorted by time. Sheet2 would have only the data for account "A" sorted by job number. Sheet3 would have account "B"...

When a change is made to any of these sheets I want the other sheets to be updated.

Now that I have wrote this out it seems to me that a "worksheet event" macro might do this for me...

But can you write an event macro into all the sheets that would not result in a loop (event macro on sheet1 changes sheet2 which triggers the sheet2 event macro...)?