conbine lists from multiple worksheets
 

i am hoping some excel wizard can help me here and not tell me i should use
Access. anyway, i have several lists of names on about 15 tabs/worksheets.
each list is a different length, one column wide, and i want to combine them
to come up with 1 master. i don't want to eliminate duplicates and i want it
to auto-update if an additional name is entered on one of the tabs.

i've tried the "offset" function with the insert name range which works, but
i can only have up to 7 functions in my formula, and since i have more than 7
tabs, i don't know how i can use it.

so alas, here i am seeking some guidance because i feel i'm close, but oh
sooooo far away.

thanks