Here LaDonna, you can play with this.

passwords for LaDonna - closed.xlsm

passwords: bs123, rd123, bb123, bw123, lr123, & admin

Each password opens up a different part of the workbook.
  • the Summary tab shows the rollup, with a date range that can be set to selectively pull records
  • the List tab shows the dropdown options
  • the Passwords tab shows who has access to what and with what password; you can change the passwords in column A
  • the Front tab is the landing zone that everyone hits first
  • only the Admin password has access to everything