Combining lists on different sheets into one list on a different sheet

[jpayne@ET]

Hey guys,
New here, and I like what I have seen so far as responses go. Very helpful.

Anyway here is my deal. I am making a workbook that has different sheets for each worker, in which they fill out time spent on various projects.

On another sheet, I want it to list all of the lists together.

For example:
The sheet "Tammy" has 5 things listed. The sheet "Monty" has 8 things listed.
I want the total sheet to list the 5 things Tammy did, and then when it finds nothing more, to start listing what Monty has. Obviously it would need to be flexible to grow as both Tammy and Monty enter more information. And also, there are more people contributing than just the 2 sheets for Monty and Tammy.

I have it listing the stuff Tammy has done, and if it finds nothing it lists what Monty has done, but only in the same cell row. So, right now it is listing the 5 things Tammy has done and then listing the last 3 things that Monty has done, which is close.

I feel I am close, but can't quite get it.

Here is my current formula:
=IF(Tammy!A3="",IF(Monty!A3=""," ",Monty!A3),Tammy!A3)

I have tried different modifications, which fail horribly, so this is as close as I have gotten.

Thank you!

-Jay

PS: I am working in Excel 2007, but I need it to be compatible with the previous versions.