Enter Source Range
Type the range manually (e.g., "A1:D10") or use the range selector button
Select Destination
Choose between New Sheet or New Workbook options
Name Your Sheet
Provide a custom name or use the default
Execute Operation
Click "Copy & Paste" to complete the transfer