If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet.

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Excel has its own functions for simple layout, but if you are writing a report or similar and want to use data from large Excel tables, it’s easy to link the two Office programs.

Learn to use the best new features in Excel for Microsoft 365 in Windows.

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how.