connect multiple worksheets

[LandNiki]

I have a report that gets updated once a week with data on 6 projects. Each project has its own spreadsheet. There are 10 projects in all and so the six projects in the report are subject to change, but not often. The main report has fewer data fields represented than each spreadsheet. I want to be able to update the report and have those changes reflect on the individual spreadsheets and vice versa. Sometimes the updates include moving what is in row 6 to row 1 as project priorities change. Sometimes I will be adding rows.

How might I go about doing this? Currently I am using no formuals - it is all just text.

Thanks very much!