Take Information from closed workbooks

[Dave69rock]

Hi

I have a folder called Top Ten and every week a new workbook will be added to the folder called Top ten Wk1 and so on until week 52

I need a workbook called Year to date that will look into each workbook and copy columns A, B, C & D into one list and if a duplicate name is found to add Columns B, C, & D to that name.

Please find attached a sample workbook

Sheet1 shows what the 52 workbooks will look like and sheet 2 shows what the Year to Date workbook will look like and the results I need.

Hope you can help

Dave