#
I want to copy specific cell values from multiple workbooks if conditions are met and paste them in a master workbook to a specific cells.

1-Every one of the multiple workbooks is located in its own folder.
2-All this multiple folders are located, for example in "D:\Documents and Settings\Data".
3-Compare the range G7-AE7 in the master workbook1,(sheet1) to the header at cell (A4) of all the multiple workbooks (sheet1).
4-The criteria is if one of the cells at the range G7-AE7 equals one of the the headers at cell (A4) of the multiple workbooks.
5-If the criteria is met, then look for the values from the master workbook in the range A12-A49 in the column C of the workbook that has met the header criteria.
6-when the value of each cell within the range A12-A49 (master workbook) is found at a specific cell in the C column(source workbook), then copy the value of the
cell from the D column(source workbook) and paste it in the appropriate cell of the range G12-G49, AE12-AE49(master workbook).
Example if A12(master workbook)=C61(source workbook), then copy D61(source workbook), and paste it at G12(master workbook).#