@Shaopingfu
By *in the same worksheet* you actuall mean the new Workbook? Right?
Yes, workbook
@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.
This is exactly what I want. Thank you very much.