Dave,

that is a good idea but one that relies too heavily on the maintenance of
this master list. Since this is for a model that then gets passed off to
different department heads who can then add a new account number at their
leisure I'm not sure this is the best to go. Especially since this
"implementation" is already underway. I suspose if we had started out this
way it MAY have been doable.
To answer you question, every Account number worksheet has the same layout
save one cell.

Any other direction you can think of? Even if I can't roll it out this year
I'd attempt to modify the existing model so that next year's upload is that
much easier..Thanks.

-Brian


"Dave O" wrote:

If the account numbers are not consecutive then using a counter would
not work. Probably the most intuitive way to do this is to create a
new tab in the workbook called something like "Batch Process", and then
list all the tabs you want to include in the batch. So if column
A1:A10 was the list of accounts for this batch, you could write code to
start at A1 and loop through A10. (Or you could write it to loop until
the code encountered a blank cell.)

I can't tell from your description if the data you need is *always* in
cell B52 (for instance) on each tab, or if it will vary from tab to
tab. On your Batch Process tab you could include information in
columns to the right of each that indicates what cell(s) to pick up.