VBA Copy Data Sheet 1 to Sheet 2 Based on Value of cell on Sheet 1

[elybm1]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[/TR]
[TR]
[TD]15-0013[/TD]
[TD]1234[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sheet 2[/TD]
[/TR]
[TR]
[TD]15-0009[/TD]
[TD]5432[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15-0010[/TD]
[TD]8569[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16-0012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15-0013[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15-0020[/TD]
[TD]4587[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16-0033[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have an excel workbook which holds a data table on Sheet 2 based on an order number (example 15-0013). I want to populate cells on the sheet by entering data on sheet 1 and pushing the information to the correct cell on sheet 2. In this example i want to push the value 1234 from cell B1 on sheet 1 to the correct row of Sheet 2, column B based on the value in Sheet 1 A1. I assume this includes looking up the correct row on sheet 2 and setting value of cell(correct row # and column B) equal to the value in sheet 1 B1. I am struggling to find an example online to follow for this VBA code. I would greatly appreciate any help you can provide on this example.