Macro to extract specific Column Headings & Data

[howard]

I have a workbook called 40110.xls containing several sheets. I have another workbook called V Statements and need a macro in this workbook to extract the following column Headings and the data below these columns from the workbook 40110.xls. These headings do not appear in the same column on the various sheets

Doc.
Number_______________________________________________________________________

Doc.
Date

Amount

Your assistance will be most appreciated