Hi Ryan, Can you help me please! I can't find what I need anywhere.

I have 5 event booking worksheets for 5 events throughout the year with information in rows of addresses (which are pulled through from a master spread sheet or business database using:
=INDEX(BUSINESS_DATABASE,MATCH(B40,BUSINESS_ID,0),2)

Where column B is a business ID which is entered to pull through the corresponding address into columns H-R

Following these addresses which are in columns H-R there is information about whether they have paid to be an event or whether we have paid them e.g. -£20 or £500 (where a minus is an income) all in column AP. I want to be able to search all 5 worksheets (which have the same template) and collate all of the positive vales. And pull through these rows for B (Business ID), H-R (the address info), AP (amount), AS (date recieved), AT(date paid), AU (order no), AV (Coste centre), AW(project code, AX (account) into a new worksheet. So that I can then link this worksheet to an expenditure voucher to raise payments.

Can you help me with this please. It is similar to the forum post above but with more rows and more than one worksheet.

Many thanks
Isabel