=(SUMIFS('[Budget Spreadsheet with subaccount.xls]Data'!$F:$F,'[Budget
Spreadsheet with subaccount.xls]Data'!$G:$G,$B9,'[Budget Spreadsheet with
subaccount.xls]Data'!$A:$A,$A$1,'[Budget Spreadsheet with
subaccount.xls]Data'!$E:$E,"<="&'data input'!$A$1))

This SUMIFS function does exactly what it is supposed to do, assuming that
the user just wants data for a single fund located @ $A$1. However, now I
want to be able to pull data for multiple funds, which means there will have
to be some looping. I'm thinking of using the 'data input' sheet for user
input, but I'm not sure how to pull this off. Can someone give me a shove in
the right direction?