I am working on an excel database. I have an excel file where I make a
sheet including a question for students. At another sheet I calculate
all possible answers. The problem when I create a lot of questions the
workbook gets to large and very slow.

what I want to make is a system where I export the sheet including the
question and the sheet holding all answers. All of this sheets become
one database. From the original sheet I can summon the database and
select the questionsheets (& answers). Once selected I want to insert
them in the original file. The first step I need to take is to export
an entire sheet en import it later via a selection window.

Is there anyone who has experience with this kind of exchange between 2
workbooks? Any help would be great considering I have not much
knowledge of VBA.