Consolidate Patient Excel Data

I have an Excel workbook that contains several worksheets, each holding different information about the same group of patients. The one field that appears in every sheet is Patient Number, and that will be our master key.

Your job is to pull every row from every sheet into the first sheet so that the final result is a single, continuous table where each patient’s records from the various sheets line up perfectly against their Patient Number. In that master table, the Patient Number column should stand out—either bold, shaded, or otherwise formatted—so anyone can locate it at a glance.

Once the merge is complete, I need to be able to filter the consolidated table quickly by Patient Number to isolate an individual’s full history. No other special sorting or grouping is required, but all numerical, date, and text values must remain intact and matched precisely to the correct patient.

Feel free to approach this with VBA, Power Query, or any other Excel-native method you prefer as long as the output meets these acceptance criteria:
• Every patient appears exactly once in the master table, with all related fields filled from the source sheets.
• No data shifts, omissions, or duplications.
• Patient Number column clearly highlighted.
• Built-in filter enabled on the table, defaulting to Patient Number.

Please deliver the updated workbook plus any code or instructions needed for future refreshes.