I hope someone can help...

I have a workbook to 'map' sample storage (so the user can go straight to the storage container and find the sample they need). Each worksheet corresponds to one area of the storage container and has the sample ID's laid out in a grid in specific cell ranges. Each sample ID can be duplicated several times as we store multiple copies.

I need some sort of macro to look through all these cell ranges on all the sheets and then list each unique sample ID in one column, with the number of times that ID occurs in the next column. The idea is to see at a glance which samples are running low.

Many thanks, I've managed to use macros for several other tasks on this workbook but I can't get my brain around this one.