Pulling out a single column and then a new column containing the value from a single cell in power query from a folder of files

I have a folder of excel files which are all the exact same format. Sheet one has a bunch of information all across columns and rows. The format is key values (names) and then other stuff but importantly dataset specific values at the top (in this case im looking for the date the report was filed). I have tried to pull the information out and can pull the columns out but I am struggling to understand if its even possible to do what Im trying to do.

My output from my query should be for each file: file name, column 1, and then a second column that is ONLY the value taken from column 3 cell 4 (report date). So what I will end up with is column 1 and next to each entry in column 1 the value from column 3 cell 4 which will be the same for each separate file but different between files.

If this is the wrong sub for this please redirect me, thanks.