How to make an inventory of incomming goods

I need to make an inventory file in excel with all the incomming and outgoing
goods which we are about to store in our warehouse. More specified it's
kitchenfurniture and accessories. The sheet needs to contain name of
customer, ref.number,code description of the goods,In or out, date,remarques.
The functions : search on all of this items + making links with other
documents such as freight letter for example.

Hi
Bit more than a little help with some code to be fair!
Lots of professional Excel people here who earn a living writing that
kind of project, and they would expect to be paid for this...If you
don't get many replies, that is the reason.

regards
Paul