One control sheet from many sheets

[DerrickHNJ]

Hi everyone,

I'm new here and I've been using excel for over 10 years now. Everyone at my job looks to me for excel help but I have a problem coming up with an automated solution for this recent problem.

I work the tax department for a large corporation and we have many spreadsheets ("lead Sheets") for our book/tax adjustments. These lead sheets have many columns of information (Entity, description of adjustment, GL account, Corptax Account, Corptax event, Provision amount, Return amount, and status, etc...).

We have a combined sheet that we did this past tax season where we actually went into all 120 lead sheets and manually linked to these lead sheets so that if the amount changed it would update on the combined sheet.

My question is:

If the formats are the same on the lead sheet as they are for the combined sheet is there some type of forumula or lookup that would be appropriate for this situation? Also, for carrying over this combined sheet year to year will there be an issue with updating the links?

It's hard to describe in words here if you need to look at the spreadsheets I'm working with I can attach them.

Thanks in advance for any thoughts.

[Richard Buttrey]

Hi,

Yes please, but preferably not all 120

Just the control and one of the lead sheets would suffice, and even then it doesn't have to be all columns / rows just as long as there is a representative sample.

Rgds