Hi Alan

Thanks for the reply. The Vlookup function , which I am familiar with is fine, However, there is a formula in Col D in the source workbook. I have several sheets for each month in the destination workbook and don't want the value updated. I want it to remain constant

Howard