Alright, so here's the deal:

I'm creating a tracker in order to organize incoming issues/requests broken down into a worksheet per individual section here in the office. However, I need a master sheet that will autopopulate as I'm filling in the individual sheets. I know how to use the VLOOKUP function, but it's an absolute reference that permanently links single cells. If A is submitted before B I want them to show up A and then B in the master and vice-versa, not have them hardwired into individual cells. Is that possible?