Formulas needed to replace macro that was organizing data

[sephus730]

I need a formula to replace a macro due to my companies security settings. In the attached sheet I would like the information on the data sheet to be listed in the tables on each sheet corresponding to the desk# In other words I would like the data from worksheet DATA to display on sheets 1-20 starting with row 16 if the date matches and then for only the data to be organized on the corresponding spreadsheet. Should keep in mid that the info on the data page will change frequently I just need it to line up properly under the correct columns without having huge spacessample.xlsx

[FDibbins]

Welcome to the forum

It might help if you added a few sheets with (manually entered?) results, so we can see what you want