Get data from existing sheets in workbook
 

Please I need help running macro.
I have a workbook with daily report worksheets named by date, 06-01, 06-02,
......., up to 11-11
In last worksheet named MasterWS I have starting from Cell "C1" to Cell
"FJ1" headers with dates going from 06-01 up to 11-11
In Column A I have Customer Code and in Column B Customer Name.
How can I get Column "D" from each worksheet on MasterWS's column that
corresponds to same date?
Help would be really appreciated.
Thanks & regards
farid2001