I have 6 identical ranges (cost centres with same accounts and fields)
that are in separate worksheets. I want to compile into one dataset
and save as a text file. Do I loop through the ranges and copy and
paste into a worksheet then create the text file from that worksheet
or can I compile a dataset to save as a text file without creating the
worksheet as an interim?

Any help is fantastic. Thanks heaps!

Dean