Auto update a list and don't show blanks
 

I have a workbook with multiple sheets, various users will add information on
certain sheets. These sheets then need to link to a master sheet which will
have all the information.
To do this I can use hlookups etc. or straight linking. However I don't know
how much information is going to be inputted so I need to allow for 100 rows
of information on each sheet. This means I have lots of blank columns.
If I use an auto filter then that has to be refreshed each time to add the
new information. Is there another way of doing this so it works automatically?

Finally I can't use macros as this needs to run on both Excel 2003 and 2007.