Creating a database and need help with counting functionality across various sheets in the workbook

Hi   I'm after some help. I'm putting together what is going to be a rather large database of tracklistings of artists and song titles in Excel. There are numerous sheets and I'm wanting to collate...