Linking Check Registry to Income and Expense

I would like to use my check registry(sheet1) in excel to automatically fill in my expense report(sheet2) and Income report (sheet 3). What type of formula would I use? Thank you!!