Create master list from several worksheets of data

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.

I've attached one of the worksheets - hopefully this makes things clearer.
Thanks

Hi, just for any future reference - I used a pivot table looking at the same ranges over several worksheets to solve this (the first time I ever used one, a steep learning curve!) Thought I'd post back here as I would not have thought of a pivot table as a solution, it may help someone else.

With a bit of trial and error I managed to produce a table with the sample ID in one column and the number of times that sample ID occurred in the specific ranges in the second column - which is just what I wanted.