Macro to consolidate from 2 Sheets to a Result Sheet

Hello All,
I am using Excel 2010 and require help with a macro.

I have a folder C:\Sample

There are many workbooks in that folder each with a Sheet name ‘Data’ and ‘Stores’

Data sheet is an excel Table with several Columns in Row 1 (See Sample Attached)
Stores Sheet is having 3 Columns (See sample attached)

The macro should run on all the files in the folder C:\Sample on all workbooks and look for the sheet Data and Stores and create a new sheet ‘Result’ as shown

I have colored and made the desired output on the Result sheet for explanation purpose
See Row 5 on Result Sheet for further explanation of extracting data

Any help would be appreciated
TIA
Rashid Khan

Hello All Experts
Any help with my problem please?

Thanks