Which Product

I have a VB.NET web application that needs to:
1. open multiple Excel files
2. copy a sheet in one file to another
3. delete the Excel file that I copied from so I only have 1 file when complete

Aspose.Excel to serve your requirement 1 and 2.

About 3, you can use System.IO.File.Delete method to delete unused files.