Hi. Im pretty new to Spreadsheets but im doing a project at school which i
need some help with. Could you please answer these 2 questions?

1.I am making a spreadsheet for some coursework and the project is for
tickets sales. I have different sheets for different events like "Dizzee
Rascal" as one event and "ColdCut" as another event with a page which is sort
of like a home page just showing an overview of the events so far so it shows
how many tickets the event "Dizzee Rascal" has sold so far etc.

So im wanting for example from the page named "Dizzee Rascal" id like cell
E12 to also show as exactly the same even when changed on the home page.
Sorry if im not explaining this very well.

2. Also am i able to make a formula which makes the page lock after
something like "12hours and 10mins" and maybe make the formula say "EVENT
CLOSED" near the bottom of the page if possible.


Thanks in advance.