I have a large variable number of worksheets (this changes each day after I import the data) in a workbook which I need to collect, from all of them except sheet1, the data from column A and append in order to a new sheet called “Results”. The data in Column A has blank cells which are required to be copied over into the Results sheet. I continually have to update the data on the sheets so if I rerun the code it will need to delete the Results sheet and append again. The sheets are named numerically 1 - nth with a sheet called 999 which must be appended last. Once appended together I then need to save the “Results” worksheet as $$12-12.txt file to a specific directory e.g. (C:\temp).

Thanks in advance