Add new worksheet instead of saving as a new file

I have a workbook with three standard format sheets and one datainput sheet. Currently, the code below is selecting one format based on the datainput and saving the workbook as a new file with the modified standard format.

How would I change the way this code works. Instead of save the modified format as a new file, I would like to make it a new sheet at the end of the activeworkbook. The name of the sheet would be the value in cell B3 of "InputData".

So, if the dataInput screen causes the "6 cyl" worksheet to be selected, then that standard format would be updated with number and saved as a new worksheet after the last worksheet.


THANKs!!

Please Login or Register  to view this content.

Should I find another method to doing this??