Populate row based on userform input

Hello,
I need VBA to populate a set of cells with data from another worksheet based on an input into a sheet from a userform, eg I have these cols
Name, Grade, Position, Department, RE, DE, CE, HE, TE, YE, SE

The first 4 cols will be entered using a userform then how can I populate the rest RE, DE etc with data already in another sheet based on the Grade entered from the userform.

Grade. RE. DE. CE. HE. TE. (etc is already calculated in another sheet),
Offcer1 123 213 313 142 543
Officer2 222 333 444 555 666
Oficer3 135 357 468 680 225

based on the Grade I need to get the row data to a different sheet , when the original data changes the others must change automatically. I have been fighting with this for 3 weeks now but cant get it working and I am also new to VBA so can someone help me out?