Save Multiple worksheets into a new workbook and save the workbook

[parvindar]

Hi all,
Good day, I have tried to search in the forums for a vba code to

1) Save multiple worksheets into a new workbook
2) Save the new workbook in a particular folder macro free

However, there too many variations. Can you kindly point me to the right forum/direction or provide a code that i can use.

Thanks in advance.

 

[DanteAmor]

Check the following content

https://www.mrexcel.com/forum/excel...elected-saved-new-workbook-2.html#post5237971

 

[MarkReddell]

Hello, I'm not for sure what u r trying to do. However, if you could combine all data by first making all W/S into tables, then creating a Pivot Table to combine all data.