Detailed pivot table from multiple sheets?

[xdskyline]

I am an Excel novice (never used it for anything more than high school science class), so pardon me if I don't know the correct terminology. My question is twofold:

1. I am trying to create a pivot table that draws data from multiple sources. When I create a table from data from a single sheet, I get far more options as far as organizing the table and viewing the data (see "What I want Master to look like" sheet. However, when I choose to create a table from multiple consolidation ranges, I lose those options (eg I can't make the table add the costs column up to get a total without it also adding the date column).

Is there a way to do achieve the same type of table when using data off different sheets? I don't want to have to copy and paste the data into one sheet every time I want to generate the table.

2. Figured out this question.

Sample document attached. Thanks for any help.

[xdskyline]

Never mind question 2 - figured out I just had to uncheck "blank" in the filter list. Still haven't figured out the first part though. Any ideas?

[thameem127]

Is this your expecting for ? pivot table test.xlsx

[xdskyline]

That's exactly what I want it to look like - the question is: were you able to generate that table using data from the individual sheets (ie taking data from the Mike sheet and the Louis sheet), or did you use the sheet where I simply copied and pasted their data together (Mike+Louis)?

The point is, I'd like to be able to make the table draw from many sheets, as copying and pasting data from multiple sheets into one will get tedious.