Extract data from other workbooks based on date criteria

[Stephanie30]

Hi Everyone

I need a big help. It is a task which involves extracting values based on matching dates.

On my sheet1 of activeworkbook, I have dates in column B and the required data values in Column d

I need the codes to extract the required data values (i.e.in Column D) from the master workbook by matching the dates in column B of the sheet1 of my activeworkbook.

The code should open the masterworkbook and select the data sheet tab and extract the data. The dates in the data tab are in row(5:5).

This excercise needs to be repeated in 3 different sheet tabs based asper their sheet names in my activeworkbook. I have maintained the same sheet names asper the text values in column B of the data tab in Masterworkbook.

This is required very urgently bcoz of a deadline and responses will be very much appreciated.

Thanks in advance

Steph