First, sign in to your Microsoft account, and open an Excel file you want to share. Then, in the top-right corner, click "Share," and in the drop-down menu, click "Share" again.

Learn how to combine Excel files with different sheet names using Power Query. Save time, ... Power Query can automatically process the new files and update the consolidated dataset.