Hi is there anyway that I can combine separate pivot tables onto the
same sheet. I have tried to create a pivot table in the same sheet as
another one I have but it keeps posting an error that I have one or
more invalid references so it will only allow me to create one in a
new sheet.

Also is there a way of having one pivot but posting multiple views of
different data pivots on one sheet?