Combine Data from Multiple Sheets to Single Sheet

I am sure that this has been asked but I have been unsuccessful in locating a solution.

I have file with over 90 sheets (90 days of data) and need to combine all into one sheet. The data sometimes exceeds 65k so an additional filter of copying only the data with an amount greater than $1,000.00 would be required. Please see the attached.

Any help would be greatly appreciated as copy/paste is a real inconvenience.

Cheers!
Mike

FYI - Sorry this was posted in the wrong forum. Can one of the moderators please move?

mpquin,

See the attached workbook "Data Filter AutoFilter copy values greater than 1000 from all sheets - mpquin - SDG.xls", and run the "CopyData" macro.


Have a great day,
Stan