I have been asked to create an excel based report from data contained in another workbook

The donor report is AD columns wide and 35000+ rows long, and contains data relating to credit notes issued to customers over a period of years. Row 1 contains the column headers and column F contains a numerical code (from 1 to 50), denoting the reason for the credit note i.e. damaged goods = code1 short delivery= code2 goodwill=code3 etc, column h contains the date the credit was issued and column J is the credit note value. Other columns contain incidental data.

Basically I am trying to write a report where each worksheet relates to a specific code (up to 50 worksheets) for crddits raised in a specific period i.e. Jun 12, each sheet should visually replicate the format of the donor report and contain all column data.

Additionally there is a totals sheet which summarises the number of credits raised for each code and their value, by month.

I can achieve parts of the job, but cannot pull it all together. unfortunately using ODBC or Microsoft query is out of the question due to the way that our network is configured

I am sure i am overcomplicating things.

Does anyone have a simple method of extracting data from 1 sheet, filtering it and sending to a number of other sheets already filtered. Ideally it should be a refreshable report following change of date criteria

OR do I do it manually by cut and paste

Microsoft XP with Office 2010. Donor report is xls written in office 2003

Thanks for any advice and help