I am not finding any results for this so maybe it can't be done. I want to script pulling some data from servers, 2 different lines that will give different results, and put each set of data into 2 tabs in Excel, naming them appropriately with the server name, and another piece of data that I will add. If I can't do it on the fly, maybe combining 2 separate csv files into one, with 2 tabs.
The end result is one csv file, with 2 tabs for each server, containing the data I pull with the script.
I hope that makes sense.