I have mutiple workbooks in a folder. All workbook data is on 'Sheet1' and
have the same format.
Row 1 contains headers.
Column A2:A20 contains dates
Column B2:B20 contains reference #'s such as 1356, 1378, 1478 etc
Column C2:C20 contains data pertaining to the Reference #.

How can I set up a macro on a master workbook that will pull the data from
all workbooks in the folder based on the information entered on the Master
Workbook.
As an example, on Master Workbook, Sheet1, A:1 = 1356, then all instances of
1356 and related data from all workbooks in the folder would be displayed on
the Master Workbook?

Your expertise, as always is appreciated