Hello!

I've looked for several days and I didn't find an answer, so I need your help. I have 5 workbooks and each workbook has 10 sheet , I whant to collect all the information in a workbook named Master ( e.g. Workbook1 sheet A, Workbook 2 sheet A, Workbook 3 sheet A, Workbook 4 sheet A, Workbook 5 sheet A in a workbook master sheet A; Workbook1 sheet b, Workbook 2 sheet b, Workbook 3 sheet b, Workbook 4 sheet b, Workbook 5 sheet b in a workbook master sheet b from etc. b. I need to copy the data but not the head of the table. Data will be added each day.

Is there any possibility of a macro to do this?

I hope i has clear...If not please tell me...I don't write in English very well.

Thank you in advance!