BAndrews --
Open one project containing the overallocated resource, then click View -
Resource Usage. This view will show you all of the projects to which the
overallocated resource is assigned. Open each of the other projects to
which the resource is assigned. Once all of the projects are open, click
Window - New Windows. Select all of the open projects, select the Gantt
Chart view, and then click the OK button.
Microsoft Project will create a temporary master project with all of the
open projects as subprojects. Apply the Using Resource... filter in this
master project and then select the resource whose task assignments you wish
to see. While in this view, you can also use any of the various manual
methods at your disposal for leveling the resource's overallocation. Hope
this helps.