Let's say the 1st column needs a drop-down list with 3 Procedures:
Back Adjustment, Massage, Nutrition Book
The 2nd column needs a drop-down list for the Pricing Types: Regular,
Medicare, Cash
The 3rd column will then automatically fill in the correct pricing
according to the "Procedure and Pricing Type"
(This is because the price is different depending on which of the 3 is
chosen: Regular, Medicare, Cash).

For example purposes, let's say these are the prices:
Regular Medicare Cash
Back Adjustment $80 $40 $60
Massage $60 $20 $40
Nutrition Book $30 $15 $20

The 4th column will be Quantity, and the 5th Total Price (These are
just basic calculations: Price x QTY=TOTAL) This ofcourse is not the
hard part for me, LOL.

One way is to start by putting the above price table in Sheet2!A:D.

To fill in the third column of Sheet1, put this in Sheet1!C2 and copy down:
=VLOOKUP(A2,Sheet2!A:D,
IF(B2="Regular",2,IF(B2="Medicare",3,IF(B2="Cash", 4,5))),
FALSE)
The idea of the IF() is to select a column of Sheet2 to use based on what's
in Sheet1!B2.