Output data to excel worksheet, and get data in new tab per run

[Shaopingfu]

How can I set the output formula, to get output data always in the same worksheet, but each run output saves in a new tab with the running date (mm-dd-yyyy) and time? 

[Qiu]

@Shaopingfu 
By *in the same worksheet* you actuall mean the new Workbook? Right?

[Shaopingfu]

Yes, workbook

[Qiu]

@Shaopingfu 
We can use the DateTimeNow() Function to get the current DateTIme then you can convert it to the format you want.
And we can use the DateTime now to compose a FullPath of output workbook and use the Date Time now as variable of Tab Name.

Below is a quick sample. Hope it helps.

[Shaopingfu]

This is exactly what I want. Thank you very much.