hi,

i'm using workbook it has 6 sheets, each sheets has 114 headers the is same for all sheets.

i want to merge the data all sheets into single sheets. i need only 5 headers only

How to do in VBA