Consolidate Filtered Data From Multiple Sheets Excel VBA Macro

In this video we see how to consolidate filtered data from multiple sheets into separate sheets for each unique entry using Excel VBA macros. The macro loops through each worksheet and filters each unique entry in column A, then adds a new sheet for each unique entry to copy/paste the data. It is a modification of a previous macro (see here), that allows to combine data from various sheets.

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:

[AmanKumar-ebvd]

Is this possible to copy same data in new workbook instead of same sheets. Please help