Populate data from different sheets into 1 page based on criteria

[JeromePl]

Hello - I am having some trouble on how to automate excel to grab bits of data from cells in other sheets (same workbook) and bring it into a single page summary. For example, I am wanting to populate this table and based on what serial number is typed in (B-002 etc), the table below will populate with data from the other sheets based on that value. This is what is looks like:

Device Information
Serial Number	B-002
Firmware Number
Device Main Board
Device Display Board
Device Imaging Module
Device Interface
Device Heater
Device Reader

An example of what the other sheet looks like:

Sheet 1

Serial Number	B-001	B-002	B-003	B-004	B-005
Discipline	Eng	Sys	Soft	Eng	Eng
Device Location
Device User	AUD	US	US	AUD	AUD
Firmware Release	0.1.0	0.0.7	0.0.3	0.2.1	0.0.0
Variations

This is what sheet 2 looks like:

Serial Number	B-001	B-002	B-003
Main Board	123456	34353	24567
Display Board	2468	345345	34523
Imaging Module	1357	34534	323435
Interface	24689	3457765	345777
Heater	123489	23423	234234
Reader	8879	445756	5676874

I have tried playing around with 'INDEX' or 'IFS' - =IFS($D$3=B-001, 'Device Config Tracker'!F12, $D$3=B-002, 'Device Config Tracker'!G12 ) but I would need to write out 250 different IF statements as I need to have this setup for 250 different serial number (B-001 to B-250). Is there an easier way to perform this?