Generate new workbooks based on column value from multiple works

[Closed]
Report
Posts
1
Registration date
Monday August 14, 2017
Status
Member
Last seen
August 15, 2017
-
I am a beginner in VBA. Basically I need a code that generates a new workbook for each specific column value in multiple sheets. The key in each sheet is the column Group.

In total there are 6 sheets in the original file with the following columns. Sheet General Data

Location Project Project Manager Status Group

Sheet Costs

Location Group Project Costs

Sheet Costs Last month

Location Group Project Costs last month

Sheet issues

Location Project Project Manager Issues Group

Additionally there are two other sheets in the wb that need to be transferred as well but kept as they are. ("Overview" and "Summary").
Thank you.