Question: how to export data from one excel sheet to another?
Answer: Highlight the cell or group of cells you want to copy to the other workbook, and then select "Copy" from the Clipboard group on the Home tab.
Choose the worksheet you want to copy the data to, and then select where you want the data to appear.