Database that needs automatic overview page

Hey, I'm going to bould a database in excel that shows input/output of things and whos the owner right now.

It looks something like this:

A	B	C	D	E	F
	JELLYBEANS			LOLLIPOPS
	Michael			Jordan
1/1-15		7/1-15	1/1-15		7/1-15
	Jordan			Michael
8/1-15			8/1-15		13/1-15

What i want is an overview page thats connected to the database and updates automaticly when i add something new.
Something like this:

ITEM	USER	OUT	IN
Jellybeans	Jordan	8/1-15
Lollipop	Michael	8/1-15	13/1-15

What formel can i use for that? Ive tried index+Count, but it wont work..

Thanks!

Can you post a sample spreadsheet that doesn't have defining/identifying data?

Here's an example!

Sorry but I dont see the connection between sheet 1 and sheet 2...?

The thing is that i what that structure for several reasons.

Is there no way to solve my problem and still keep the structure i want?
I mean there has to be some formel that brings the last date on a specific row to a specific column?