Looking for a way to Merge Rows From One Sheet based on Serial Number to be added to another sheet

Steve099 This can be done in various ways. If you are an MS365 subscriber in the Current Channel you could use the new FILTER function. Alternatively, use a series of traditional VLOOKUP functions or its successor XLOOKUP. Exactly how, depends on the actual structure of your data sets. 

And then there is always Power Query (provided you are not on Excel for Mac), that can fairly easily merge large data sets, without copying, pasting or a great number of formulae.

If you could share and example of let's say 10 rows from each data set (with matching serial numbers, of course), I or someone else here could provide the solution you need. And please mention what Excel version you are on.