Hi Paul, thanks for the response.
Yes at the end I have a file with the five queries in five different tabs. I then have a number of other tabs that read the data and do some charts/analysis.
I still want them all in the one file that has the exisiting charts etc. in it, but for it to save...