How to Copy Data From One Spreadsheet to Another in Excel 2010. There are multiple ways to transfer your data across Excel worksheets and workbooks. ... How to Ungroup Tabs in Excel.