Hi everyone.... I have just joined the forum as i desparately start my quest to understand microsoft vba! I am posting a 'live' problem i have as this seems to be the best way to learn. In summary, i have 10 separate workbooks, all housed in one folder. The format of each workbook is different, however, each workbook will have the name 'total' appear at least once in different columns. I would like to create a macro which imports all of the workbooks in the folder into one spreadsheet housing each workbook in a separate tab and naming the tab the name of the relevant workbook. I would then like a separate tab to be created called 'summary' which summarises the name of each of the workbooks in one column with the total of the totals from each workbook in the next column along so i can check it all reconciles. Any help/direction would be greatly appreciated. Thanks. Matt