Separating data into individual sheets

Hello everyone,

To summarize, I have a data sheet of almost 37,000 lines. It is a customer purchases database with around 10 columns.

I need to separate the spreed sheet based on each individual customer (which is located in column G) and put this data onto separate tabs (sheets)

I already did research before hand and tried the code that was posted here on this link. http://www.ozgrid.com/VBA/item-worksheets.htm However, after trying to make it work, the best I could do was have it the company's separated into individual sheets but I couldn't get any of the data to go along with it.

Can someone help me modify the existing code that was provided on the website above to make this work or provide a new one? I have attached a test excel so you guys can see what my document looks like. Any and all help would be greatly appreciated. Thanks again.


-Shawn