Boy, I hope I dozed off while entering that question. That's the only way I could explain it.
What I meant is I would like to end up with one Excel file with 3 worksheets. But when I tried the DoCmd.OutputTo I ended up with just the last query.  I'm guessing that you can't get multiples but still wanted to ask.

You can do it with more complex VBA automation, which I'll be showing in a future video.