Trying to create a somewhat complex summary view from multiple views...

Hi all,

I was hoping i could get advice from the forum concerning a View i'm trying to create. I understand conceptually what i need to do, but am running into a wall when it comes to the details.

Currently, i have a template form that asks for the following:

Current Date: [response is date]
Member1: [response is a, b, or c]
Member2: [response is a, b, or c]

That form is duplicated several different times. It's split into multiple forms because the form is input by different "leaders" for the people they are responsible for. As in:

Form A (filled out by Andrew):

Current Date: [response is date]
Member1A: [response is a, b, or c]
Member2A: [response is a, b, or c]
...
Member5A: [responsei is a, b, or c]

Form B (filled out by Bob):

Current Date: [response is date]
Member1B: [response is a, b, or c]
Member2B: [response is a, b, or c]
...
MemberxB: [responsei is a, b, or c]

What i want to do is to create a single view that compiles the form data across all of the duplicate forms grouped in columns by date (that is common amongst all forms) and in rows by members:

CurrentDate1 CurrentDate2 ...

Member1A response response

Member2A response response

...

Member5A response response

Member1B response response

Member2B response response

...

MemberxB response response

...

I have a good understanding of how i need to build the form once i can compile all of the various table data into a single table; i do not know how to join all of the data in my various tables into a single table to create the form i need.

Any help would be appreciated. I hope i was specific and clear enough in my question.

Thanks very much!