Extract data from 1 specific field in multiple workbooks

Hi everyone!

I'm looking for some help in this VBA programming because I managed to get a VBA programming going to list files in folders and subfolders in a separate workbook, but I would also like to extract in another column the value of a range, so that the ending table can add up all the numbers at the end.

You will find enclosed the copy of the document I'm working with. There is no personal information in it. I would like to add the fetched range value in column F.

Let me know if you can help, or if you need more information.

Thanks!