This seems so obvious i'm worried there must be something else wrong, but anyway:
If cell A1 on sheet 2 has anything entered into it, putting the formula =SHEET2!A1 anywhere else in the workbook will make whatever it was appear there too.
@moth started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
This seems so obvious i'm worried there must be something else wrong, but anyway:
If cell A1 on sheet 2 has anything entered into it, putting the formula =SHEET2!A1 anywhere else in the workbook will make whatever it was appear there too.