Reports: Joining multiple sheets by column names

Let's see if I can ask this correctly.

I would like to have a report pull from 2 sheets.

Sheet A: Resource (Drop down of people in department), Department Name, Title

Sheet B: Project Plan (Possibly plans but lets stick to 1 sheet for now), with Assigned to , Status, etc

Assume I make the Resource and Assigned to the same column name.

I would like to pull the report to join these sheets so that I could have a nice summary of:

Resource, Department, Title, # of Tasks by Status

Every time I attempt this, the data for Department and Title have no information for Status, etc. The data for Status and etc have no information for Department and Title.

Still fairly new here, so maybe I am just missing something? Thanks in advance.