sheets from workbook copied into another workbook

[messiah166]

I have a workbook with an undetermined amount of spreadsheets, could be anywhere from 20 to 30 sheets. I need cell A32 from each sheet copied into another workbook and sorted. Is there a macro I can put into a workbook_open function that will auto do this? Sorting and all?

Thanks,

Messiah