%%*********************************************************************************************************************
% Name : copy_sheet_ExcelX
% Author : Pruthvi Raj G :: www.prudhvy.com
%
% Version : Version 1.0
% Description : A script intended to copy sheet from one excel file to another and renaming the sheet required.
%
% Input : 1. Input_file & Input_SheetName
% 2. Output_file & Output_SheetName
%
% Date : 30-Sep-2019.
%
%
% Examples : copy_sheet_ExcelX('D:\Pruthvi\Test_file.xls','D:\Pruthvi\Test_file_output.xls','Input','Output')
%
% % Output sheet name will be same as Input sheet name.
% copy_sheet_ExcelX('D:\Pruthvi\Test_file.xls','D:\Pruthvi\Test_file_output.xls','Input')
%
% % Takes 'Sheet1' as Default Input Sheet
% copy_sheet_ExcelX('D:\Pruthvi\Test_file.xls','D:\Pruthvi\Test_file_output.xls')
%**********************************************************************************************************************

Answer to below Questions :
Moving excel sheets within excel file
Copy and Paste Excel Sheet into New WorkBook
Copy XLS Sheet
How do I copy and paste excel spreadsheets from one excel file to another?