I will add in the last bit to add another list table below what you have already produced as I think I see how it works. Will give it a go anyway. yes, the master file has the original source data which is then pulled into this one as it has different tabs from different sources

p45cal - A massive thank you for your help. this is excellent and works a treat. Wizard indeed !