Open Office Calc help requested

I hope someone on this list is using OO Calc.

I have a simple spreadsheet that is slowly gaining in complexity and is
moving beyond anything I know about spreadsheets (yeah, I've managed to
dink with computers for 20 years and have avoided spreadsheets until
now).

I am doing work for my church where I create a new sheet within a work
book for each service that I count a portion of the collection.  For
each date I copy the previous date's data to a new sheet and then
replace the donors' data.

Quite simply, I am finding a common text string appearing in multiple
places in the same sheet, specifically a date string, and I want some
way so that I can edit one cell's text and have the change take effect 
in a number of other cells.  However, I'm finding the OO help system to
lack (or I lack the necessary skills to know what they're talking about)
a good HOWTO type of tutorial for many of these topics.

Also, as I tried to learn about the macro language I was quickly
overwhelmed.  C, I can grok, this stuff dove off into custom
applications when all I want to do is some simple automation.

Thanks!

- Nate >>

-- 
 Wireless | Amateur Radio Station N0NB          | "We have awakened a
 Internet | n0nb-k7QPB+T73Rh94W/[email protected]               | sleeping giant and
 Location | Bremen, Kansas USA EM19ov           | have instilled in him
  Amateur radio exams; ham radio; Linux info @  | a terrible resolve".
             http://www.qsl.net/n0nb/           | - Admiral Yamamoto
-- This is the [email protected] list.  To unsubscribe,
visit http://www.complete.org/cgi-bin/listargate-aclug.cgi