Is there a way to create individual files from a multi sheet excel

[Guest]

I am new to Excel 2007 and I have a couple of questions. Often I need to
send users an excel file that contains multiple sheets of information. These
multiple sheets come from indivisdual excel documents that I copy into one
document. Is there a way to quickly create one large excel document from
multiple excel documents and have each individual file be a separate sheet?
Also if the reverse is possible, that would be great. Essentially saving
individual sheets as separate either excel or tab deliminated text files
would be extremely helpful.

 

[PY & Associates]

Essentially we would in a new file (Thisworkbook);
list all individual files in a column;
in a loop,
open each file,
copy the sheet that you want,
paste in a new sheet in Thisworkbook;
close the file;
loop
save Thisworkbook in a new name.

The reverse is not much different.