Generate new workbooks based on column value from multiple works

TheBeginner Posts 1 Registration date Monday August 14, 2017 Status Member Last seen August 15, 2017 - Aug 14, 2017 at 05:10 AM
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.