Merging separate Excel files in one

[DiyaParial]

I have about 8 individual Excel files (1 sheet each) and I want to merge them all in one file with 8 sheets. I need to write this is a vba macro, does anyone have any sample code that can help ?

 

[Derek]

Hello DiyaParial

Not sure exactly what you mean by "merging" and why you would need vba to do this; Do formulas in these workbooks refer to each other? If not, why not just right click each sheet tab and copy the sheets to one book?

regards
Derek