My wife started a cheerleading buisness last year and I built a spreadsheet to help her keep track of each kid. I have a tab for each squad showing each kid with check numbers, dates and amounts. I also have a total and owed column that I used basic formulas for. Now she wants to be able to invoice each kid monthly. My question is, can I download an invoice template and have it pull data from each tab without having to manually enter it? Everything I've seen so far are just generic invoices where she would have to enter the data herself thus creating double work.
Any suggestions would be greatly appreciated.