Afternoon...

I'm trying to formulate the best way to rollup data that is broken out
by X # of worksheets (or account #s) and re-list them on one worksheet
with their appropriate values. This model lists each account number as
a worksheet that then captures each object code (and related data) as
values in Column A11 through A350. Excel is not reading each worksheet
with a 3-D reference with other functions, INDEX in particular. I"ll
try breaking it down again.

a range of worksheets have unique values (account numbers) in CELL D5.
For all worksheets where CELL D5 is an account number, I'd like to
create a new worksheet listing each "CELL D5" down a particular column
where I pull each piece of information specific to each worksheet or
CELL D5 value.

I hope this is making sense. Any input would be greatly appreciated.

-Brian