i'll answer your question more in-depth and in-thread tomorrow, but basically vba has a palette viewer which lays all the data bare for the person to see. you find that palette of the one you are looking for by simply coagulating all of its hex data.
occasionally, a palette will be lz77-compressed/"stored weirdly." these palettes literally just have a stray byte every 8 bytes and are purely cancer that serve for 0 purpose. in this case, really just searching for the first four colors without the first one (so the second, third, and 4th colors) usually suffices. other times see the colors being stored horribly and with random bits in various places (see the pokémon menu). i honestly look at the routines to find these ones, usually...