referencing data from another spreadsheet within same workbook

This is a continuation of a project with many parts. Previous threads provided valuable information. Hoping to get more help.
Problem: Workbook contains several spreadsheets, each containing data relating to specific equipment. Current arrangement has each spreadsheet with over 3000 lines copied from the Main Page, where all data is entered. Because of the formulas below, many of the cells in Column C of each spreadsheet are blank. Only those cells that match the criteria contain data. Column D on each spreadsheet collects all pertinent data and sorts from largest to least. I want to reduce size of each spreadsheet by eliminating copying all the dates and all the TAPC values from Main Page, and just include only those TAPC values specific to equipment. Many of the formulas were provided through this forum. I tried the following formulas, all without success. Either I got error messages that stated I had too many arguments for the formula, I get an error message that highlights a parenthesis, or I got the largest number for the Year regardless of Source.

=IF(AND(MATCH("Person*",'Main Page'!N$3:N$5000,0),YEAR('Main Page'!B$3:B$5000)=E$3),LARGE('Main Page'!D$3:D$5000,D11),"")
This produced the largest value for the specified year without factoring the source.

=IFERROR(LARGE(IF(YEAR('Main Page'!B$11:B$5000)=E$3,'Main Page'!D$3:D$5000),D11),"")
This produced a blank. If I replace blank at end of formula with "NO" I get "NO"
Edited workbook provided.