Hello guys,

I have several sheets with tickets in the "B:B" ranges.
I need to get all the info from the "B:B" ranges and copy it in one singe "B:B" column in my "total" sheet. (for example I have 10 tickets in Sheet 1, 20 tickets in Sheet 2, so I would have all 30 tickets in "B:B" in the "totals" sheet)
Is it possible to do this with code instead of the IF command?

I would appreciate any assistance and would like to thank you guys for all the help you are providing! (already assisted me twice today!!)