Hi need help in PDF data extraction and pasting in Excel

I have a Excel containing filename in column A. I need to create a bot to read the file name in column A, open that file from folder and extract few days from the PDF and paste it back to the same Excel. Any idea how to do it.
Any help would be appreciated and thanks in advance