Automatic data entry in different sheets

Luxio1997 

This solution will work if you have access to Lambda.  I've created a function to roll-up the sheets.

3-D reference 'AllSheets'

='Mr. Esposito:Mr. Cristella'!$A$3:$D$302

'Applicants' constant
={"MR. ESPOSITO"; "MR. BALESTRA"; "MR. CRISTELLA"}

StackApplicants - this creates an array of applicants. Each applicant is repeated 300 times to match the 300 records (potentially) pulled for each sheet.
=DROP(REDUCE("", Applicants, LAMBDA(a, v, VSTACK(a, EXPAND(v, 300, , v)))), 1)

'RollUp' Lambda.  Consolidate all sheets. Filter out sheets where the requested date is empty.
=LAMBDA(sheets,LET(
    stack, VSTACK(sheets),
    records, HSTACK(TAKE(stack, , 3), StackApplicants, TAKE(stack, , -1)),
    FILTER(records, TAKE(records, , -1) <> 0)
))

Sheet level formula:

=RollUp(AllSheets)