Consolidation of Workbooks into single workbook

Hello everyone;

I'm looking to run a VBA script that will take all excel spreadsheets within a specified directory and copy a named range "Data" from each worksheet, and place it into a consolidated worksheet.

"Data" array is tentatively B2:B16. However, these files are being sent to many resources to consolidate, therefore the range can change.

Subsequent records added via Column, not by row. So worksheet's 1 data would be A2:A16, and worksheet's 2 data would be B2:A16.

Names of the worksheets are variable, but all worksheets within a given directory will need to put imported.

My VBA skill is about as developed as a 2 year old's language skills. Could anyone assist me?