VBA for listing Products in All Excel Files in Folder

[e.isayev]

Hi Excel Gurus.
In my new job encountered with a challenge. The solution of my problem will save my time. However I am pretty good at excel functions but I am sure that this problem cannot be solved with functions. Thus asking for your help. Appreciate all kind of suggestions and help.

My partners archived more than 1000 excel files in one folder and each of these folders contains Product names with its prices. All these products start at cell F7 and its numbers changes. Some of them only one and some more than 15. They are in the same row. F7-G7-H7 etc.

Yesterday I was able to find VBA code to list only file names in folder. But Its not enough unfortunately. I attach the file with the Folder picture. In "My VBA" sheet there is macro that I found. But for me the most important is "Improved Ver." sheet. And there I simulated the desired result. In one column I want to list products and there file names in front of them.

In my real data there more than 1000 excel files (all of them in 2003 vers.) and each of them contains 1 to 20 (or more) products. In the end there will be about 10000 row listed. I use Excel 2007.

Thank you in advance