Search for pdf files by date or title

Hi,

I use a folder called Account scans to hold all my scanned accounts and Invoices.
I save each in the folder under the following criteria - name - inv No. - date

Now what I would like to be able to do is to have a spread sheet with search as per the attached example which would search the Account scans folder for any PDF which matched the search criteria.

Now - this additional thing might no be possible but having found the searched file is possible to apply an auto hyperlink to the file in the folder - or is that not possible

Assistance appreciated