Macro to Match Data from 2 different Sheets

So I have been entrusted with the design and script work on a worksheet compiling data from various sources.

I've never worked with Macro before and so far have done surprisingly well, but I've hit a snag.

We have 3 sheets in one file. Moisture, ERS, and Raw Data. I have created macros that pull in outside data via a button on the Moisture sheet and another one from a different set of data on the Raw Data sheet.

The data is then compiled on the ERS sheet. My problem is that the data from both sheets may not be in the same order (Raw Data also has points that do not have corresponding moisture calculations).

So in ERS the first Column is the Sample Name (transferred in from Raw Data), the second left blank for any notes, the 3rd is a multiplier value calculated from the moisture sheet [=IF(ISERROR((Moisture!C10*Moisture!E10)/(Moisture!B10*(1-Moisture!D10/100))),"",(Moisture!C10*Moisture!E10)/(Moisture!B10*(1-Moisture!D10/100)))], the 4th and 5th columns are the raw data transferred from Raw Data.

I need the calculated data from the Moisture sheet (colomn 3 on ERS sheet) to match up with the corresponding sample name in column 1 of the ERS sheet (which was transfered in from Raw Data). If there is no corresponding sample it would leave the multiplier as 1. I understand that I only need to have the transfered moisture calculation from the Moisture sheet match up with all the data from Raw Data. I'm just not sure how.

Can anyone help?

Please attach a sample workbook so we can help you better.