Thread: Update references in Excel 2003

Hello everyone!

This is my first post, I hope you can help me.

I have a very simple book on Excel, the content amount of 100 sheets in a "summary sheet" that is, in cell A1 of the sheet 101 gives me the result of the sum of the 100 cells A1 the other leaves, and also to several cells.

The problem is: 100 printed pages (all in the same format) and 100 different people with different data to be completed, and then I deliver the data and I need to capture for the "summary sheet" throw the final data. Obviously it is working double that capture the same information twice. He managed to send me information in the spreadsheet already captured by electronic mail (which is not explained by sloppy work in order to optimize the flow of information) but copying the sheet to the workbook that contains the "summary sheet" The formulas I make no reference error and led to the results, i.e. I get the "sheet 1" with the data, go to the book and remove the "Road 1" (empty) and copy the "Road 1" (with data) that I received.

How can I get the sheets referencing the "summary sheet" to throw me the results? Ie, "update" the reference to the current sheet?

Certainly there are other methods to solve the problem, but I get this job and I will take some time to change "hobbies" on information management and in the meantime I have to solve this problem.

The book is done with formulas, with no links (which would have been better option to do this, among many others of course!), I read some posts that refer to links or other things that I have helped solve the problem.

Thanks for your time and I apologize for the length of the post!

Hello.

The only thing I can think of is to keep all the pages of information collection in the same folder and reform the summary sheet linking formulas to leaves in that folder, but if you say you do not solve the problem links, no...

Of course the links solve the problem, in fact I am already working on a solution, but it is starting from scratch, the detail is that I want to know if there is a way to import and replace the leaves that are empty (with the same name course) and is recognized by the "summary sheet" and "original." At first the question of whether it can be and second that is not the only case I have to solve and as you know, time is money

Hello.

If there is I do not know, maybe with a macro, but I think you take more time.