I have officially arrived at a dead end. I know what I want to do, but
for one, I don't know if it's possible, and for two, even if it is
have no idea how to do! I would much appreciate some help on the
matter.

To make it easy for me to explain I have uploaded the workbook to
savefile.com
http://www.savefile.com/files/3037321

Referring to the worksheet called ProjectRegister - cell A8, I would
like to select a risk source from a validation list. The validation
list would use column B in the RiskSource as it source. Once a risk
source had been select it would insert a number of rows depending on
how many risk were associated to that source. For example, if railway
(which has three associated risks) was select as the risk source, then
two new rows would be inserted and the existing row in row 8 would act
as the third. The rows that were inserted would copy the same formulas
and validation as row 8 (I have created some similar code for this on
the Add Row command button).

The following risk information will be automatically entered in the
ProjectRegister from the RiskSource:
· Risk Title (ProjectRegister column D) to Risk Title (RiskSource
column C)
· Risk Description (ProjectRegister column E) to Risk Description
(RiskSource column D)
· Action Description (ProjectRegister column N) to Action Description
(RiskSource column F)

Other Possible useful information:
· There will be hundreds of Risk Source Records
· The user can enter a unique risk, which has no source ID. In this
scenario the user will select custom in Risk Source filed and enter
risk manually.

I would much appreciate any help on this problem.

Lui