To combine data from multiple worksheets in Excel, you can use the "Consolidate" function or the "VLOOKUP" function. The Consolidate function allows you to merge data from different worksheets into one, and the VLOOKUP function helps to retrieve specific information from different sheets.