Thank you oeldere for the step by step guide, it does make a lot more sense now and I will have to play around with it some more to really understand it's working. A few questions though:

1. Should the Output tab update automatically every time data is changed in the source tab?
2. If I were to assign a macro to a text box, would this run the vba code that you set up and generate the Output tab?

I guess what I'm trying to figure out is, if the Output tab doesn't update automatically, how would I generate a new list every time the source data changes.

Thanks to all for your help so far.