Best way to display list of options

There's a page that has a list of options like below

  • 002-12345
  • 002-16516
  • 003-21565
  • 008-15168
  • 001-86841

Currently, we display it inside a box and user has to scroll up or down to select whichever account they wish. Though this can be overwhelming if the user has 10,000 accounts, then there can be 100-200 pages of account lists like this. If the user has to select 005, they need to scroll through 10 pages to get to that. Well, we can ask the user to make some favorite and show those first then show rest in the list, that's an improvement for quick selection but no other idea comes to my mind. Is there any suggestion you guys have?

I attached how it looks currently in a picture.

enter image description here

Edit: @Mike M asked some great questions so I added below information: Desktop, user clicks on one of the accounts in this list and we load some statement for that account on the page. Table selection only it has account number and name columns, there's also a search functionality users can search accounts too, this table makes it easier to select ideally.

Tags: