Excel Macro help to merge multiple files

[ssganesh]

Hi,

I am having 3 excel files in a folder and i want to merge the data's t
new excel file

for eg:

file one has 2 worksheets
file two has 2 worksheets and i want the data in sheet 1 of file one an
file two to be consolidated to a new sheet of a new excel file similarl
for sheet 2 of the files.

Note: both files don't have constant range of entries in thei
cells,file one has entries from (A2:U60) and file 2 has entries fro
(A2:U75)

Can anyone help?