Is there a way to have the data in an excel document be linked to another
excel document?

For example, I want to keep track of my charges and deposits to various
credit/debit cards. I'd like to have an excel document for each card. I'd
also like to have an excel document that keeps track of all card activity
with a column that notes which card the entry affects. Is there a way for me
to only have to input data into this master document have the other excel
documents automatically look at the list, select relevant entries based on
the card, and display them without me having to enter them myself?