MATCH function over seperate tabs

I know a bit about functions but not enough to figure out why my formula stops working when I move the table data to a new tab.

I have a several tabs with data, which I have created the data validation drop down lists, individual small tables for several areas of the spreadsheet that all gets collected on the "Daily Working Tab".  I want the next table removed from the "Daily Working" Tab and put on it's own tabs of "Payee's"

Right now, I have a formula that checks the value in column “AK” for each row in the table and returns “Y” if there’s a match or “-” if not, so I can see if I’ve added it to the relevant month for each of six months: 

=IFERROR(IF(MATCH($AK8,$E$8:$E$80,0),"Y"),"-")

This works fine on the same tab, but as soon as I move the data to another tab, the updated formula

=IFERROR(IF(MATCH($AK8,'Daily Working'!E8:E80,0),"Y"),"-")

no longer works, even after fixing the “#REF!” error by pointing it to the correct tab and table to "'Daily Working'!$E$8:$E$80'". 

I’ve read about using several INDEX, VLOOKUP, XLOOKUP, nested IF, and MATCH combined functions, but I still can’t get it to work and baffled where or what I am doing wrong or need to do to get this to work.  I have even split the information on different spreadsheets and it works but this defeats the purpose of having this all on one spreadsheet and different tabs.

Probably simple to fix.  Any help would be greatly appreciated.

TIA WPH.