Thanks, i tried your steps.
The macro does read the files, but it kept overwriting at row 7 on the master file. How to rewrite the code such that it will flow to row 8 after picking up the data from the first file? Thanks