Well why not copy them to one tab for searching? Will make it much easier, it's fairly easy to loop through all your sheets and append the data in each sheet to the bottom of another