Help with macro needed.....

Hello,

Really the help of a pro here....

I have a master data sheet which details all payable items in our finance system and the user they are currently sitting with.

To give you an idea its about 1000 lines and 8 columns. Coloums are split like
A - item ID
B - Item Stage
C - Current user (most important)
D and onwards have the date, value , client name, ageing etc

What I want is a seperate worksheet (within the same workbook) created for each user and that user name to be the tab name. I also want a value total (column I) summed up for their items.

Obviosly the number of items each user has is a massive variable rangeing from 1 item to 100 items.

All feedback welcome