Hi all,

Excuse my completely newbie question but I have virtually no experience with programming Excel. What I'm trying to do is grab addresses from a certain column on a certain sheet from many Excel files in a directory

So my task is:
-Loop through all Excel files in a certain directory.
-Grab the values of cells in a certain column (they are all in the same column) up to a point.
--This would be everything in between the first non-blank cell and the next non-blank cell inclusive: 3-5 lines worth.
--There are no headers. It is an invoice-like sheet.
-Place each value in a specific column in a new workbook.

If I can provide further information just let me know.

Frankly, I don't know where to start. Any push in the right direction is certainly appreciated. Somebody kick this new Excel programmer in the head.