trying use index match to pull information from database to individual sheet

Hello
Take a look at the attached reply. It uses an helper column to bring back the relevant rows of data. This could be replaced with an array formula if needed. Also a pivot table might be a non-formula option.

Hope this helps.
DBY