Excel Spreadsheet - Update data across multiple sheets

Hi There

I have created a spreadsheet using a range of data from A1 through J100 with cells having different sizes, data, text and numbers.  Generally the core information will remain the same however I need to be able to utilise the data across a number of spreadsheets and for that data to be updated from time to time.  So I would like to know how to set up the spreadsheets so that when data is input or edited on Sheet 1 that data is also edited and included on the other spreadsheets. That is through Sheets 2 to 6 for example.

Hope you can help.

Regards

Spencer