Macro to Create separate sheet for each Unique Value in Col G and put SUMIFs Formula

Hello All,

I am using Excel 2010 and have attached a sample of my problem

I have two Sheets Data and Master

Data Sheet has repeated Store Names in Col G

I want the macro to copy the Master Sheet as per unique Store Names in Col G

It should place the value from Data Sheet E5 to G2 and Sheet name in Cell L2 of each sheet
Eg in the attached there would be total 21 Sheets i.e Master plus 20 Sheets for each Store

Then I would need the SUMIFS Formula in Col F to Col J on all the Sheets

Col F : =SUMIFS(Data!$K$5:$K$84,Data!$B$5:$B$84,Master!C5,Data!$F$5:$F$84,Master!$L$2)
Col G : =SUMIFS(Data!$K$5:$K$84,Data!$B$5:$B$84,Master!C5,Data!$F$5:$F$84,"<>Reject")
Col H : =SUMIFS(Data!$H$5:$H$84,Data!$B$5:$B$84,Master!C5,Data!$G$5:$G$84,Master!$L$2)
Col I: =SUMIFS(Data!$I$5:$I$84,Data!$B$5:$B$84,Master!C5,Data!$G$5:$G$84,Master!$L$2)
Col J: =SUMIFS(Data!$J$5:$J$84,Data!$B$5:$B$84,Master!C5,Data!$G$5:$G$84,Master!$L$2)

Hope to get some help

Thanks in advance

Rashid