List all .xl* files in folder then pull value from cells of each

Good Day!
I have scoured this site and others for an answer to this and perhaps am not using the correct keywords.
I am trying to create a file for other users who need to pull a list of all files in their directory, as well as values from specific cells within those files. The trick is the file names and directories will change based on the user, but the cell references will not. I would love to use an indirect formula, but there will be 50+ files in each user's folder and therefore will not all be open.

I would prefer to execute this without VBA, but will if needed. Also to note, our systems are locked down such that we cannot download add-ins.

I am attaching a file that shows my desired outcome. Please let me know if you need more information.

Thank you!
N

Jerry, thank you for your quick reply. This does just what I need!

Cheers!