export character sheets

I need to get all my character sheets, across all Scrivener files (for each book) into one file together, to use as a reference. Since i write quite a few series, and also blend/share characters across other books, i need a master file of all my characters. Probably i will put them in onenote, but i need to be able to access them all, even if in a txt file, so i don’t have to type all the character details in again. Anyone know how i can do this?

I’ve already tried compiling from a collection, but that just creates another tab in the binder for ONE book. I’ve tried dragging and dropping from one scrivener file to another and that didn’t work either.