Searching for data across multiple sheets and copying to one main sheet

Hi there, i'm currently using this macro, which is helping me find data in one sheet and copying it to another. However I now need to search for the data across multiple worksheets and then copy it to one worksheet.

Please Login or Register  to view this content.

Basically, once it's finished searching on the v.sat worksheet, it then moves to the q.sat, neither, q.dis and v.dis worksheets.

Any help would be really appreciated.

Had a play around, but still no joy. The macro I have there is something that i lifted and shifted from another site.

Maybe I should look at starting a new macro rather than changing that one. Basically i'm looking for a macro (like the one i've copied), which will allow me to search for a criteria. Excel will then look through the sheets called V.Sat, Q.Sat, Neither, Q.Dis, V.Dis and copy the row which contains that criteria into a sheet called 'Get Info'. It will copy the row beneath the last one and continute until it's found all of the row with that criteria in. Once it's found and copied all of those rows, it will stop.

An alternative approach:

Please Login or Register  to view this content.

I'm getting the following error with this:

Runtime error '13':

Type mismatch

Thanks so much for the help so far by the way!

On which line does it error? Do you know how to check the code using F8? If not, post a small sample workbook.