When filling more than one sheet in the same file, with data that comes from two queries, one for each sheet, By the time it's filling the second the first gets emptied.
Only the second sheet has data and runs the macro.
The result file has a suffix in the name, maybe "yyyy-MM-dd".
To add the suffix, Toad Data Point ( TDP ) creates a new file as a copy with the suffix in the name, and does this for each export.
As there are more then one exports being processed, TDP creates the file again for each export and overwrite the last created one, in the end, only the last created remains, with the last data exported and the last macro executed.