VBA to move data with same headings from multiple sheets to one sheet

[Crosby87]

Hi,

I have a workbook with multiple headings and data streams but I only have about 8 that i need to extract into one large workbook, with the associated data fields.

Does anyone know any VBA what would let me extract only the fields with the same headings, or even better to write a list of fields headings to extract.

Thanks greatly in advance

 

[oldbrewer]

it would help if you made up some pretend data and show us your desired outcome.