I'm using Microsoft Office Excel 2010.

I have a folder containing 52 workbooks and in each workbook there are three worksheets. Not all of the worksheets have the same heading.

I want to combine all 52 workbooks into one. I keep all the files into this folder directory:

C:\Users\AS-4738G\Desktop\C OMBINED DHL\BSB

I want to use VBA but I don't know the coding for it or how to use it.
...