Theer is a column if the open workbook which gives the list of workbooks which are to be referred and a range of values to be pased against the specific workbook name