How do you update one inventory sheet to one row in another sheet

[nhbcai]

Hi. Just so you know this is my first time on a forum.

What I have -
I have different sheets that contain the full history of different items that need checking on a weekly basis eg -
sheet 1 = Support Plans,
sheet 2 = Pocket Money Forms,
sheet 3 = Pocket Money Forms.
On each sheet there are column headings
'Next Due Date', 'Date Checked', 'Checked By', 'Comments' and 'Actions Taken'.
All information is entered one row at a time for each weekly check.
I then have a 'Main Sheet' that shows a row for each items sheet eg -
Support Plans,
Pocket Money Forms,
Pocket Money Forms.
I then have headings 'Date Checked', 'Checked By', 'Comments' and 'Actions Taken'

What I would like -
To just look at the 'Main Sheet' as a quick reference to see that the weekly checks are being done.

Question -
How do I get the latest weekly information for each 'Item Sheet' to update automatically in the 'Main Sheet' in its corresponding row?

I hope I have explained enough and not written too much.

 

[bertie]

Here is one possible way using formula.

Column G uses the COUNTA() function to determine the last row in each of the specified worksheets.

We then use this in an INDEX() function to retrieve the data from each sheet.

Excel Workbook
	A	B	C	D	E	F	G
1	*	Next Due Date	Date Checked	Checked By	Actions Taken	*	Lastrow
2	Support Plans	3	04/12/2011	bg	none	*	3
3	Pocket Money Forms1	2	04/12/2011	bg	none	*	2
4	Pocket Money Forms2	5	04/12/2011	bg	none	*	5
Main