Macro help to copy data from 5 workbooks and appending it in 1 new workbook

[sankhla]

Hi,

M new to excel

I am working on to automate a process
please help me out

here is the problem statement

there is a folder
D:\ABC\ABCDEFG\Automation
this folder contains
Sheet1
Sheet2
Sheet3
Sheet4
Sheet5
Master

I want a script which will
automatically open all sheets from 1 - 5
and copy data from the to the master from second row, appending the sheet1 data and
from the bottom of it adding sheet 2 data and likewise.

I am trying few codes but not able to figure out any solutions pls help.

Regards,

da