Looking for a macro the auto add sheets based on data, add the data and hide the sheets.So

So basically, I have a sheet named Form that the user puts data in and then a button to automatically add the data in a new sheet named Data. In the Data worksheet I have a table and the last column is named Week. I have made a formula to state the Week number starting from Monday. For example, I log in first entry on 11-28-2015 and it is considered week 1. If I log in entry the next day 11-29-2015 it is going to be week 1 again, but if I log in entry on 11-30-2015 it is going to be Monday and it is going to say Week 2.
And then I need a macro that is going to automatically make sheets named "Week #" and add all the data in the worksheet from that Week. And then I want the sheets hidden and I am going to add a button how to hide/unhide them. (I know how to do that)
Basically, I need a sheet for every week.
I tried something but I kept getting an error because I have duplicates in week numbers so the system was trying to make worksheet "Week 1" and then for the next entry again "Week 1".
I am new to excel and know little about VB.
Data worksheet week numbering starts from G4 and keeps going down.

Thanks for your response.
upload.xlsm
It is a project I am working on. It is a hypothetical work calculator. I want to have separate sheets for every week to see how much I worked every day. I am really new to excel and I don't really understand what you mean by the database. If you could ELI5 i would be grateful.

I guess I don't really need to do seperate sheets for each week. I just thought it would be cool to have the information whenever I need it. My initial idea was to get data for every day and then compute the check and then in the summary add every check by week and see what I made for the whole summer. I was thinking of adding a line chart aswell to see which weeks i made the most money.
This is a class project I am working on. We haven't really made macros in class and we haven't covered Data Advanced Filters. So any ideas on how to make this would be greatly appreciated.
I really like excel that's why I am doing more than what we've covered in class. I just want to make it good and complicated