To make a cell repeat text from another cell on a different worksheet, you need to copy the information from the first cell & then paste a link in the cell you want to show it. I do it all the time in Excel 2003, but if iirc you've got 2007 - hang on a minute & I'll just find out where the relevant tools are.
Actually it's in a really obvious place, which is unusual for Excel 2007 - usually all the function want to use are hidden away in obscure places.
So - copy the text you want, go to your new sheet, or new book, then click on the arrow under the paste icon for the Paste menu & choose Paste Link, and your text will appear.
I use it at work all the time so that on our provision map the children's targets appear on both their own page and the page for the intervention they are doing, so the SENCO can see each child's individual targets and all the targets for eg Units of Sound.
You can set up the link before you've put the text in the first cell if you want - the cell you paste to will just have a 0 in it because that will be the value of the formula for a blank cell. When you add text to the first cell, or change it, the second cell changes too.
I can't find an easy way to resize a lot of pictures in Vista/Excel 2007 - you can insert a lot of pictures, select them all by holding down Ctrl & use the set height & width tool to change them all at the same time, but it's very awkward as the pictures will take up so much room when they're first inserted.
It's annoying it would be really useful to me too, and because I have a vague memory of having done something like this ages ago & I can't remember how. If I did, it was at work though & I won't be back there now till September.
No, we're a junior school, so we have our own set of hoops to jump through.
I'm the IT manager & the SENCO & I have spent the last couple of yeas creating this massive Provision map spreadsheet showing all the interventions we do for all the children on statements, SA, SA+ & CA with their targets for the term, which are reviewed each term & a new one set.
Every so often either the SENCO or I will get a great Idea for some way to improve it & it all gets changed. We've now just about got it into a form where it's really easy for the teachers to use, which probably means that somebody somewhere will change the goalposts again and we'll have to alter it...