Hey @anjani_priya
use excel application scope inside that use get workbook sheets so it will give all the sheets inside that excel file now use for each to iterate the sheet one by one inside the for each read range and enable the preserve format option and then use write range .
or you can use copy method
Excel Application Scope (Source Excel)
Get Workbook Sheets → Store sheet names in a variable (e.g., sheetNames).
For Each(iterate over sheetNames):
Copy Sheet→ SourceSheetName to TargetWorkbook
Excel Application Scope (Target Excel):
Paste Sheet→ The copied sheet goes into the target Excel file.
Save Workbook → Save the target Excel.
Close Workbook→ Close the target Excel file.
cheers