I have developed a dashboard sheet that contains data from 3 different  source sheets.  Unfortunately, it requires me to manually input the data.  Is there a way to use a formluain  one sheet that relies on data from another sheet.  I know this can be done in excel, but can't seem to find a solution


I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again.


I keep track of the hours charged to around 35 projects by people in a dozen functional areas on a weekly basis and send the monthly total into our finance team for their revenue