Hi,
I have 300 excel files and another different 300. I want to merge one
from the first 300 to one from the other 300,so that i will end up by
300 excel files each having 2 sheets one for the data from the first
300 files and the second sheet carrying the data from the other 300.
Is this possible?If possible, could you explain the steps as i am new
with the excel macros?

My files are named like the following:

first 300: datas1,datas2,datas3,.....datas300

Second 300: datag1,datag2,datag3,.....datag300

and I want to have 300 files each consisting of 2 sheets :

data1,data2,data3,...data300

so that data1 consists of 2 sheets the first is for the data of datas1
and the second is for the data of datag1

data2 consists of 2 sheets the first is for the data of
datas2 and the second is for the data of datag2

and so on................................................ .........