Hi,

I have several spreadsheets which are linked together.

Spreadsheet 1 is used to display information gathered from spreadsheets 2,3,4,5.

The way it is constructed, Spreadsheet 1 only pulls through info displayed in front page of sheets 2,3,4,5.

What I would like to be able to do is to change a cell in spreadsheet 1 (the cell is what month is being displayed), which would then trigger changes in spreadsheets 2,3,4,5 without opening them separately so all spreadsheets will display the info for the same month, as requested in spreadsheet one.

Is that possible?