Macro to extract data into different tabs for each values in column D "Group"

Hi,

I am looking for an macro to create different tabs for each values in Column D "Group" with its respective data and also considering the period 1 data. because the next time I will get data for Period 2 included in the raw data that needs to append to the values in respective tabs which is already created during the first time. If any new Groups in column D is added it should create a new tab every time the macro is executed and for the existing one the values should get append for the period values.

I am attaching the Pd1RawData

Please help

Please see attached.

It is possible to insert 5 columns infront of the existing column. After the first period data I will update some information in the first 5 column which should remain the same when the macro is run for the next; but it should append the data from the below row after the 5 columns.

Five column headers can be review 1, review 2, review 3, review 4 and review 5 which help me to update come comments in the respective tabs columns.

Please help

could someone help on this.

Is it possible to create a summary sheet with sheet names and count values in column B. Summary tab should exclude Pd1RawData tab and should create all the provide all the remaining tabs getting created with the Column B count.

Please help.