open copy and close excel

[gauravvarshney2003]

i m having mutiple excel sheets A, A1,A2,A3.......

I want to open A1 ,A2 ,A3 ..... and copy the data in A

And then close A1,A2,A3....