I have a workbook where each tab is a specific week with labor data and
another master tab that generates the invoice for the time over a given week.
Is there a way, from the master invoice tab, to copy the needed labor data
from the appropriate tab - possibly through a prompt or entering the week
ending date in a cell on the master tab? Each weekly tab is identical in
format with the data to be copied residing in cell range C2 - F8.

Thanks.