Multiple Index Match on different sheets How?

Please see the image I have tried to explain without sending a sheet I think it should be straight forward for an excel guru.
The only sheet I have is a live sheet which is full of info I do not want on here.
I have tried stripping out sheets but it breaks several other sheets

On Test Sales (to replace my current Sales) I have in G6 a drop-down eBay, Amazon, Website,
I have all my sheet working accept K6 "Final Fee"
It works when I select eBay current formula =IFERROR(IF(G6="eBay",INDEX(eBay!$A:$R,MATCH(A6,eBay!$A:$A,0),MATCH(eBayDropShip[[#Headers],[eBay FVF]],eBayDropShip[#Headers],0))*[Items Sold],0),0)

I want it to do the same but if I select Amazon in G6 it goes Amazon sheet (called AmazonDropship in Name Manager) and match SKU and grab value in the M column it's called Amazon FVF select the value there and bring it back.
If website is selected it puts a £0.00 in

https://dl.dropboxusercontent.com/u/...es%20Sheet.png

Seriously Dropbox unknown provenance!!!!
I did explain why i could not upload.
But thank you for your guidance

Hi Guys Girls

I am trying to get a new sales sheet to work with the maximum flexibility I have done 90% of it but need a little further help to finesse its flexibility. I have tried to explain in each area what I need to achieve.




Sales Tab

• SKU A6 Manual Entry
• eBay, Amazon or Website B6 Dropdown Selection
• Product Name E6 =Check Live Data tab
• F6 & G6 Manual Entry
• H6 Working OK
• I6 Working OK
• J6 The formula here must look at A6 & B6 to find what to lookup on the Sale Price Live Data Sheet**. If the SKU is not found on this sheet it then needs to look up the SKU on Own Stock Sheet look at A6 & B6 and extract the correct Sale Price***
• K6 The formula here must look at A6 & B6 to find what to lookup on the eBay or Amazon sheet only (The Website is not subject to a Final Value Fee FVF) If the SKU is not found on this sheet it then needs to look up the SKU on Own Stock Sheet look at A6 & B6 and extract the correct FVF Price K or S eBay or Amazon

There is some formulas already working for eBay but not looping through Own Stock Yet.
I have uploaded the sheet to make it easier. Would like to maintain the Index Match functions if possible.

**Live Data
J = Website Sale Price
L = eBay Sale Price
M= Amazon Sale Price

*** Own Stock
K = eBay Sale Price
S = Amazon Sale Price
V =Website Sale Price

HI

I have now realised H6 Product Cost on Sales Sheet is only extracting Price from Live Data Sheet and i need it to look at Own Stock I column Cost Per Unit

Need for Phase 2 with all the formulas working I now need advice / help with columns X & Y
My current situation is I only have column Y on my live sheet. I have some VBA done a few years ago by a helpful forum member.
In essence and without boring you to death prices change daily so I needed a solution to fix the prices after a sale.
As live data changes hourly I didn’t want my sales figures to keep changing.
So when I select Y (Yes) in column Y it should fix the values in the following cells.
H,J,K,Q and S this would lock down the sale
VBA supplied**
So I need to make sure the code is doing this.
But I also need an option to have a refund which could be in column X OR added to the dropdown in column Y as Y = Fix Sale R=Refund
The Refund needs to set columns H J F to £0.00 this should leave Profit showing £-0.20 as PayPal still charge the seller even after a refund.

It would be better to build it into column Y and rename it Status.
If this needs a new post please let me know I will recreate it in another forum topic.
Also thank you for all your help so far as you can see I have done a lot myself but a few areas do not click with me still in Excel

**Private Sub Worksheet_Change(ByVal Target As Range)


'dont do anything if multi cells selected or cell is not column V or is not input as "Y"
If Target.Cells.Count > 1 Then Exit Sub
If Not Target.Column = 22 Then Exit Sub '22 = column V
If Not UCase(Target) = "Y" Then Exit Sub


'dont do anything if Profit shows an error ie info is incomplete
If Evaluate("ISERROR(" & Target.Offset(0, -1).Address & ")") Then
MsgBox "Line details are incomplete. Please check and try again!", vbOKOnly, "Sorry"
Application.EnableEvents = False
Target = ""
Application.EnableEvents = True
Exit Sub
End If


'Otherwise....
If MsgBox("Please confirm that you wish to fix this entry.", vbYesNo, "Confirm Details?") = vbNo Then Exit Sub
'if is the last row of table then add a dummy row to maintain the formulas
r = Target.Row
lr = Cells(Rows.Count, "A").End(xlUp).Row
If r = lr Then Cells(lr + 1, "A") = "NEXT ITEM"
'change the row's formula results to hard value
Range("A" & r & ":S" & r).Value = Range("A" & r & ":S" & r).Value


End Sub