Formula/Macro for a Tally in Excel

I have a very basic knowledge of excel.
We want to create an excel spreadsheet that will tally the number of votes for a particular artist's work. There will be about 150 artist's works that will all be assigned an individual number from 1 to 150 on an excel sheet.
We will have about an hour to complete the counts to determine winners, so a short time frame.

Is there a way of creating a formula/macro in one cell -to just enter the number of the artist's work that was voted for- and have it placed as a tally against the individual piece?
Thanks very much.

Thank you for your reply.
I hope this works, have attached a sample of what we would like to do. A1 is where I explained what we would like it to do.

Just checking to see if you might have some ideas for me if my thoughts are not possible with excel sheet I posted.

Basically I am looking for a way to count votes for 150 art works - with about 500 ballots being submitted - in about 1 hour. Artists entries will be numbered 1-150 and ballots numbered the same way.
Thank you.