Not to Include Data that Moved to a New Spreadsheet

[jilly227]

I am hoping this is a quick and easy fix. I've tried to research and I get answers explaining how to pull data, which I already know. Please see the formula lines below, the second line is returning data that was moved to a new spreadsheet. I only want Active Data from the RCCSM Employees spreadsheet.

=IF(ISBLANK('RCCSM Employees'!AK5),"TBD",'RCCSM Employees'!AK5)
=IF(ISBLANK('Retired-Term'!AL19),"TBD",'Retired-Term'!AL19)
=IF(ISBLANK('RCCSM Employees'!AK6),"TBD",'RCCSM Employees'!AK6)

Thanks

 

[jilly227]

How would I use the formula above but ensure it only pulls date from the RCCSM Employees spreadsheet. So that if a complete row is moved into the Retired-Term spreadsheet it would not show up in the spreadsheet that comes from the main spreadsheet. I hope I am not being too confusing.