First time poster but I've been following the forum for a couple months now. New to VBA so excuse my ignorance. Basically, I've been compiling code from multiple sources but ran into a road block with this new project. The workbooks I'm working in have multiple worksheets (20+), and I'm looking to make a macro that searches for multiple string values ("PQ", "DQ", and "Visited") on all worksheets, and then copies the found entries and their respective rows to a Summary Report. The code I've put together searches the multiple string values but only on the first worksheet. I'd appreciate any help or advice to see if this was at all possible!