I've created a workbook with three sheets: Sheet1, Road 1, Road 2.
Then I entered the sheetname e.g. Road 1 in cell A1 of sheet1.
The cell next to that (cell B1) contains the data which will be copied.
Now go to Sheet1, right click on the tab and select the last option (view code) and insert the following code:
Private Sub Worksheet_Deactivate()
ws = Sheets("Sheet1").Range("A1").Value
Application.CutCopyMode = False
Now enter Road 1 in cell A1 of sheet1 and a value in cell B1.
Then goto sheet Road 1 and the entered value will be there.
Note that the value will be removed.
Also note that you can create a dropdown list for selecting your sheetname by using date validation.
Let me know if everything is clear and/or if you want some adjustments.