Power Query - get single value from each of many files in folder

[xor]

Hello



In C:\Users\hansk\OneDrive\Desktop\Dokumenter\my_File s\Test2

I have 12 files and I want to extract the value in cell C1 (and only that) from each of the 12 files. Next month there may be 15 files in the folder and I then want to extract the value in C1 of these 15 files.

If at all possible I would much prefer a workbook with a working solution. Thank you.

Hans K.