linking worksheets into a pivot table

[Cathi]

I am struggling with this ...my worksheets are all in one workbook. There are
columns for: Name of Payor; Invoice #; Category of payment; Cheque #, Date of
Cheque; cheque amount

I need to get the "category of payment" and the Cheque Amount into a pivot
tablework that will tally them up and as I enter new info into those columns
the changes will be reflected in the table

How do I do that and what shoul it look like?

 

[Debra Dalgleish]

You could create a dynamic named range, and base the pivot table on
that, as described here:

http://www.contextures.com/xlPivot01.html

As you add new rows to the table, they'll automatically be included when
you refresh the pivot table.