Loop through multiple workbooks

I have a list of addresses of workbooks in a column in a master workbook.

what i'm trying to do is loop through that list of workbooks open them and add the unique values from the same column and worksheet to a scripting dictionary for use in a listbox, but for the life of me I am drawing a blank on how to do the loops. any help would be much appreciated

Thanks,

Chris