Using formuals to combine worksheets
 

Greetings. I need some help and I do not know if this is possible at all,
but maybe someone out there can tell me. Problem: I have two reports I do
every morning for my company. One report tracks data by day of the month.
The A2 through A31 is the date. A1 through J1 is the particular categories
the data falls into The second report is a daily report that uses the same
data, but is more in depth and only reports for the previous day. Every
morning I enter the same data in twice once on the monthly report, then turn
around and do it again on the daily report. Is it possible to have an input
sheet that I enter all the data into, then each sheet gets it's data without
me having to type the data in twice? Please note I do have decen skills in
Excel, but do not know Visual Basic. Any help would be much appreciated, and
if someone thinks they can help, I will email the reports so you can take a
look and better understand what the situation is. Thanks again. Cheers.