Hi all,

I have to plead ignorance as to where to start with this. If someone could get me on the right path, I'd be much obliged.

I'm trying to pull information from several different workbooks (which are invoices) into a single worksheet. I may have 40 different identical workbooks. I'd like to pull pieces of information from each of them and list them in the single worksheet.

For instance, if E13 on each of the 40 workbooks is a person's name, I'd like to drop each of those values into the combined worksheet, starting at C2 and going from there (C3, C4, etc).

I suspect this will require VBA, but can someone point me in the right direction? Thanks for your help!