Copy Excel sheets from different files

[danielkenm]

Hi,

I want to consolidate several sheets in different excel files into one excel file without importing or uploading each sheet into stata.

For example, file 1 has tab1, file 2 hast tab2. What I want is to have as an output file3 with tab1 and tab2. The tabs have formulas hence this is why I do not want to upload files into stata.

Any suggestions are much appreciate it!!!

Thanks,

Danielken