Hi RaghavendraPrabhu,
I am sorry but I do not quite understand what you are saying in your last post.

If you want more help then can you try to explain again.

Perhaps you can show me with sample data what you want done.

Show or explain to me the typical Before situation, and then show or explain what the After should then look like when the code has run

Remember that any explanation will appear OK to you because you know the project well. You need to try to explain so that someone like me who has no idea about it can understand.

Possibly the explanation lies in the Files you have already supplied. I was / am not too clear on exactly what all those file are.
I assumed the master file had already been filled from the data files, and as I had no new data files I simply used them again so as to demonstrate how the modified code would append data

On the face of it I think it sounds fairly easy to do what you want, but it is not clear to me presently exactly what it is that you want
Alan