1) Yes, i wants all the lines extracted from allt he sheets, withint a workbook to be put in a new workbook, and not in another sheet, within the original workbook

2) A new master workbook

3) Crawling through entire folder is not necessary. All the sheets, within one book needs to be crawled and all the lines for a specific account number to be extracted and put in a new master workbook.

4) Well, the new workbook can be named after the account number. That will eb awesome

You are so kind and helpful. I really appreciate all the help

------------------------------------------------------------------------------
------------------------------------------------------------------------------

Regarding the second part. There are hundereds of workbooks that need to be crawled. Each workbook has 10-30 sheets. The speicif loan number is found only in one workbook and no other workbook. If something like this can be created, where user can enter loan number and the macro will crawl the whole workbook and every sheet within that workbook, extract the whole line and put all the extracted lines in a new workbook, it will be awesome..


Thanks again