Thank you so much for this. It does exactly what I want it to.

I would also like to be able to run the macro to update the "Summary" sheet whilst I'm working on it rather than just on opening.

I also need to add other worksheets that wont be in the same format and dont need the data to import into "Summary", how do I tell it to only look at Bathroom, Plumbing, Tiling, Plastering, Labour-Sundries.

Thank you once again. Alison