Formula to show all dates/codes under same Serial Number

I have basic/intermediate knowledge of excel, but I've pull data together for a project and I want to showcase certain information on a single sheet. So far what I have is 3 sheets, first sheet with initial information, 2nd sheet of data that I wish to pull from and 3rd sheet showing the information I would like to showcase.

(File Attached) 2nd sheet consists of 6 columns titled: Date, Time, Dispatch, Serial Number, Model, Defect Code (Respectively)

(File Attached) 3rd sheet shows 7 columns: Dispatch, Date, Serial Number Used, Model, # of Serial Number previous usage, previous date, defect code (respectively, last 2 columns pulling information from 2nd sheet.


I currently use Vlookup for everything else I need, my issue is vlookup only searches once and the first occurrence.
I want to be able to search using the Serial Numbers on the 3rd Sheet and searching the entire sheet of the 2nd to pull All the Dates/Defect Codes of each Serial Number Used (respectively).

I've colored the cells of the information I want to pull into the blank colored cells I want to put them in. I hope the information is clear what I want to do. The black areas on 3rd sheet are intentionally blank/black. 2nd sheet has 685 entries to search through with 419 Unique serial Numbers.

Thanks for any help. I'm sure this is a very easy fix/formula I'm just overlooking.

Really isn't overcomplicated at all. I'm just trying to pull information for the columns and showing everything on one sheet.

Blank areas, as stated, are intentional, but what I didn't state because I assumed it would be understood that it would be for the spaces to show the information I want.

But a simple Countif for each SN to show how many times it appeared in the 2nd sheet data (Thusly being previously used # of times, forgive me for not including that if it was important)

All I need is to find a formula to figure out the pull info from 2nd sheet to show each # of previously used. I saw {=small()} but I don't fully understand that formula to use it.

Vlookup, as mentioned doesn't work for all uses of the SN. This is basically trying to find a trend in things.