For a pure formulas-automated play which works to pull in and stack data from
up to 12 identically structured individual sheets (this would be your
individual voucher sheets) into a single summary/master sheet (your Totals
sheet), you might wish to try this sample from my archives (nicely rendered,
full details inside):

http://www.savefile.com/files/236284
Auto summarize n stack lines from 12 primary sheets.zip

The desired stacking sequence for data from the 12 individual sheets within
the summary sheet can be defined easily. Just ensure that the sheetnames
entered within the summary sheet's R5:AC5 are consistent with those on the
actual sheet tabs, ie match exactly, except for case.

Data will be stacked continuously, all neatly bunched at the top, w/o any
intervening blank rows. You could then apply autofilter on the stacked
summary table.

As-is, the sample construct caters for a max of 125 lines/rows expected per
indiv. sheet x 12 sheets = 1500 stacked rows (max) in the summary
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Savage" wrote:
I have multiple worksheets and any time something is entered on one of them I
want it to show up on my totals page. As an example we have mulitple sheets
with the headings. They must be all in separate sheets and can not be
combined into one.

First sheet

[Voucher Number] [Branch] [Invoice] [Customer]
12344 Fred 12345 Frank

Second sheet

[Voucher Number] [Branch] [Invoice] [Customer]
2222 Sussex 0003 Sam


Totals Sheet
[Voucher Number] [Branch] [Invoice] [Customer]
12344 Fred 12345 Frank
2222 Sussex 0003 Sam