collecting data to specific workBook

Hello dears

This is first post for me here, wish you help me.
I usually do this task manually for this need macro to easy do it as it repeated every week.
I've folder named (customersForms) contains subfolders each one has number of workbooks and beside the main folder workbook called Customers_list, which the vba code will be attached into, each time code run chick the folder called (customersForms and all subfolders to copy data from all workbooks (sheet 1) and past them as transposed with all format, into Customers_list. then add Subfolder Name & filename in the last column.

File attached Customers_list with needed copy cells.
Row 1 headers, row 2 cells reference then row 3 sample of copied data

Pls. I searched more and failed to find what I need.
Thanks very much.

title mod....