Copy rows from all tabs in the sheet

I have an excel file with several tabs. I want to read a specific column in each tab and if matches a word or string then copy that entire row in a new tab/file. Also the second condition is if another column has certain date. e.g.

Conditions (columns does not have to be first or second, they could be
second and eighth etc. in each tab):
1. first column value = "abcd"
2. second column value = prior to Apr 4, 2015.

If the above two conditions are met in each row of all the tabs, then copy all
such rows in a different/new tab or file.

Would appreciate any help in this regard.

Thanx and regards,

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!