Working with multiple excel worksheets

[Deleted User 234324]

Hey folks,

Question really, is it possible to have multiple worksheets (seperate excel documents) and when ever data is entered into one, the others are automatically updated with the same data but possibly sorted differently?

 

[Deleted User 234324]

What im looking to do though is bring data in to a new spread sheet that wont already be defined specifically.

IE

Several rows of data,

1......
2......
3......

When someone adds a new row of data for example 4..... it automatically puts that rows data into a new spread sheet. So would referencing workbooks using Sheet1 etc still be relevant when the number of rows is always increasing?