Great handle, by the way.

You can easily do this yourself, as follows:
1) On sheet  Price, define two named ranges, Retail_Prices = D5:D300, and
Cost_Prices = E5:E300

You do not have to work with named ranges, but I find it more elegant.

2) Record a macro, call it Button1Retail
Select sheet Product
Select cell D14

Stop macro recording

3) Your macro should look something like this in the VB Editor:
Sub Button1Retail()
' Macro recorded on today's date by dummyinDOS

Sheets("Product").select
Range("D14").select

End Sub

4) Now you can add in your own code for the copying bit. Try the following, and
see what works for you:
Sub Button1Retail()
'
' Button1Retail Macro
' Macro recorded 07/08/2006 by dummyinDOS
'

'
Application.Goto Reference:="Retail_Prices"
Selection.Copy
Sheets("Prod").Select
Range("D14").Select
ActiveSheet.Paste
End Sub
----------------------------
There are more elegant ways of doing this, but for your purposes, this will
work.

Now assign this macro to your first button, and it should work.

Copy the code for the second button, modify the range to be copied from, and
assign to the second button.

I had an entirely different approach. I'm confident that you know a
great deal more about this than I do, but perhaps you could tell me
what's wrong with my thinking here. I'm trying to understand the
perspective of a seasoned programmer on the many ways of skinning
Excel cats.

I would have created buttons that set an arbitrary cell to 1 or 2,
then put formulae in each of the target cells on "Products"
referencing this cell and setting a value equal to Retail Price or
Cost Price depending upon whether it is 1 or 2.

This would allow for dynamic changes to the Prices, and more
importantly, would be easier to change next year when a third column
is added and the person who wrote the first spreadsheet has left
town, abandoning the work to someone who knows no VBA.

Whaddya think?

Very good solution. I like it. And the formulas would have an offset
function in them, with your arbitrary cell containing the column to be
referenced (1 or 2).