Search Multi workbook with multi sheet and copy

[parscon]

Dear firends ,

I have 14 workbooks and each workbook have some sheets . now i need a VBA code that when i search number , can search all workbooks with their sheets and if found any data , copy the row of them to new workbook .

for example : i have 11123542 number in 8 workbook when i search , copy all of them (the row ) that founds to workbook new .
just column A is same but other column are diffrent .

Thank you .

[Aussiebear]

I guess you tell us something more useful, like where the workbooks reside, or even the names of the workbooks, where the number is likely to be found, you know all the really important things that you left off.....

[Tinbendr]

Webpage (http://msdn.microsoft.com/en-us/library/cc837974.aspx)
About 2/3 the way down, look for
Merging a Range from Multiple Workbooks in a Folder with a Filter