PDF files to excel

Develop vba code and power query to scan pdf files in folder, log specific data into excel table and then move each file to a destination folder depending on its content. The pdfs are all structured medical reports containing patient name, id, phone, mrn, hospital etc.

Hospital names need to be mapped against a hospital definition table to identify the destination folder (by hospital) for each pdf after processing.