I won't be able to double enter fields in the master file I'm working on, there are a ton of segments, and they get updated pretty frequently.

That's a helpful starting point though, I might be able to reproduce the table with the names you made on ID_Database by returning all of the nonblank cells from the ranges on each of the earlier tabs. Now I need to figure that out when my range includes multiple worksheets :P

Thanks!