merge

if you have related data spread out over a number of locations. it can be difficult to keep track of it as you flip back and forth between the different worksheets.