Thanks for all your help. I will certainly look into userforms.

However, I have managed to do this task by manipulating dynamic arrays, the dynamic array being the list the user creates using the cell references. If anyone is interested I could show you how I did it, it's pretty snazzy.