line item extractor

Ok, so here is the deal. I have multiple excel files with 20-30 sheets per file. These files are full of data, account numbers etc etc. I have been trying to build a macro that can crawl through every sheet and extract line item. For example, in the attached worksheet, if i want to extract the rows for account number 251122812 from all sheets, and put it in a new file or maybe a sheet within the main file, how can i do it? Please help me out, there are thousands of line items that need to be extracted, and its simply a tedious work to do it manually....

Any help will be appreciated and remembered