Mirror certain data from several worksheets into one 'front page' worksheet

Hi. I am hoping this is reasonably simple to do with a bit of clever code (assuming you're clever unlike myself.)

Similar to the issue this user had http://www.excelforum.com/excel-prog...orksheets.html

The problem:
My workbook contains multiple worksheets that all contain data. I want to be able to pick certain fields accross all of these worksheets, and present (mirror) them in a 'summary' worksheet. I need to be able to specify which cells accross my worksheets I pick.

for example.

sheet2: A2, B2, C2
sheet3: A4, B4, C4:C6
sheet4: D4:D9

All to be mirrored on sheet1 (my summary worksheet) in cells which i specify. i.e. [Data from sheet2 to D2, E2, F2], [data from sheet2 to B4, C4, D4:D6] and so on.

And by mirror I mean if a user changes data on one of my worksheets, the changes are reflected in sheet1, and visa-versa.

For context, this is basically a spreadsheet that has a worksheet for different projects, and the summary page is just a presentation of key milestones, risks etc. So I want to avoid entering the same data on 2 sheets all the time.

I am hoping this is feasible. Would really appreciate any help that anyone can give.

regards.
Rob Smith

I should additionally add that if anyone can think of a more efficient way of doing this, with or without VB code, I am open to ideas.

Fantastic. I knew there would be something simple. What a great little forum this is.

I'll have a play and mark this as solved once i'm certain i've got there. Thanks very much

Hi. This has worked in that the cells that I specify are 'mirrored', however it brings up VB editor and an error " Compile Error: Sub or Function not defined."

Any idea how i can stop this error popping up - it'll look bad when I send this xls file to collegues to populate.

Yes, I did. Not sure why. Deleted the VB code and issue resolved.

Thanks for you help.