I am trying to work out an easy way to take around a dozen excel files in the same format and import them into a single master sheet, matching the column headings etc. I have tried just using excel formula which is fine but not very automated. Can anybody suggest a VBA approach that might work which I can build off to scale?