Hello,

I am creating a workbook that will help me to value publicly traded
companies. I have different worksheets for each year of earnings and then
each worksheet is broken down into 4 quarters with all the information from
the company's quarterly and annual SEC filing. I then derive various ratios
and percentages from these numbers on another worksheet. What I would like
to know is how do I create one worksheet (or form, or something) where I can
pick which year and then which quarter and then enter the specific fields
which are the same for every worksheet. Here is a quick example:
Year = FY2004 (this would be a worksheet)
Quarter = Q1 (This would be the particular heading)

-I want a "Fiscal Year" cell that has a drop-down list that will specify
which worksheet I want the data entered on
-then I want the next cell to have a drop-down list that will specify which
"Quarter" of that year I want the data entered under
-then I want to have all the individual headings and cells to enter the
numbers for that quarter

I'm not really concerned whether it is one form or one worksheet I just want
a single point to enter data entry for several worksheets that are formatted
exactly the same

I know this may be a tall order but I have already spent so many weeks
piecing this workbook together and any help would be greatly appreciated.

Cheers,
Keith