Is there a function in Excel that works like a Mail Merge in Word?

donnabrownmilvetsnc 

You can do it but you will need to install Kutools. It will add a new tab in your excel.You can download it from Following link.

https://crackingpatching.com/2019/07/kutools-for-excel-keygen.html

It will ad a new tab in excel.

Step 1: There is an option in Kutools tab to add new worksheets based on names taken from specified cells. 

In your case you can insert sheets based on Employee names or Beacon ID.

I am assuming you will create sheets based on Employee names

Now 300 sheets are created based on Payee's Name

Step 2: Then you will need select all sheets and insert following formula in Payee's Name area.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Above formula will return sheet name which is a specific Payee's name on each sheet.

Step 3: Now you can select all sheets and fill remaining cells based on lookup formula.

Note: You might or might not have to change Format of Payee's name cell (which is based on formula to return sheet name) for lookup formula to work.