On your sheet1 select the cell that should receive the data from Sheet12;
Hold down the Shift key and Click on Sheet11 << this should Group S1-S11;
enter =Sheet12!A1
Ungroup your sheets QUICKLY so you don;t forget (they are grouped),

Does tha work for you?


"Kardon Coupé" wrote:

Dear All,

apologies if this is probably a mundane question, but I didn't know what
'search terms' to put in google to return any results..

I've got a Spreadsheet with 12 tabs (sheets), I need part of tab 12 (sheet)
to appear on tabs 1-11 (sheets), so that if I change data in tab 12 (sheet),
tabs 1-11 (sheets) are changed too.. the cells themselves will never move
location, just the data within them..

Is it possible?

Regards
Paul.