Is there VBA code that would search a folder full of files, only grab information in certain rows that match values specified, and put those values in a new spreadsheet in a new row for each file with the matching information.

Any help would be great! Thank you!