Hi,

I have extracted excel sheets to one folder now i want to macro which can copy all data from sheet with same format and paste one by one in master sheet just below after 1sheet data over for ex. 1st sheet data end on column "A20" then second sheet data paste on just below on that i.e. "A21" and so on. After copy from data from sheets its will be closed automatically and 2nd sheet onwards data copy from 2nd row because every sheet had same header which i don't want.

Hope anyone understand my above question.

Thanks in advance.