I need a VBA spreadsheet to create a stock management system

I need a VBA programmer to set up userforms on a stock management system. I want to track movements of stock around the site and get a full inventory.
I would also like to be able to do other tasks with the stock which is added to the stock record.

This is for a fish farm. i need to add information about treatments given and dates, if we move the fish from one unit to another then that record should move to the new unit. I would also like to be able to enter average weights at any time to adjust the total biomass.
We should be able to see a full stock overview at any time and when we sell a batch of fish be able to see what the history of those fish was.
Groups can also be split or combined so we may only move half of a unit to another unit.
The overview should give us a stocking density which could be colour temp.

when a batch is sold their record should be archived