Copy defined columns data from several Worksheets [Closed]

Report
Posts
1
Registration date
Sunday September 16, 2018
Status
Member
Last seen
September 16, 2018
-
Hi,

I need a VBA code to copy the predefined columns (5-6 Columns) data in new excel and also need Refresh code to erase all data it has captured previously because its monthly rolling task so every time I have to run this code to get fresh data.