Search over multiple sheets and display results

Hello All,

I have the attached workbook that I am working on. Right now it searches all rows in sheet "Info1" for the words "Awaiting Parts" in column D. If it finds a rows containing these words in Column D, it displays that entire row on the "Results" sheet. I have A2:D11 set up as name: table1. This works great as it is. What I would like to do though is to search over all 3 sheets (Info1, Info2 & Info3) for the words "Awaiting Parts" in Column D and have the results from all 3 pages displayed in the same table in the "Results" sheet. I've tried a few things but nothing seems to work. Any help would be greatly appreciated.

Thanks so much,
Cedric

This is awesome. Thank you so much!!!!

One more thing, if you don't mind:
I will be adding another sheet called "Formulas" to this workbook that I don't want this macro to search in. What would I add to this macro to make this possible? It looks like the macro will search every sheet in the workbook as it is now. I would like it to skip the sheet called "Formulas".

Thanks again for your help,
Cedric

.....actually I will have 2 sheet that I don't want searched. "Formulas" and "Item Count".

Thanks

thats awesome!!!!! Thank you so much for your help!