im making an application automating the reporting process
usually i do it manually by copy-paste the information to one another
i have very little experience in vb and none in macro
here is what the application should do

1.open a new xls file
2.open new worksheet in the new xls file and rename it
3.open a few data xls files
4.copy certain data in the xls files and arrange in accordingly in the
worksheet

step 2-4 is looping depending on how much worksheet or data needed in
one workshet

5.save the new xls file

you guys have any idea? please help
atleast give me some links or tips on where to learn macro or vb fast

thanks