Index, Match, and Vlookup across multiple worksheets using multiple entries

Hey guys,

I am trying to create a worksheet that pulls information from other worksheets to create a calculation guide for products my company sells. I am having difficulty using the Index and Match functions when I go across worksheets. For example, I want to pull the price corresponding to the item (card holder) and the size of the product (3x5). Here is my current formula:

=INDEX('Two Sided Top Open'!$D$2:$D$3,MATCH('Calculation Sheet'!A3&'Calculation Sheet'!B3,'Two Sided Top Open'!$A$2:$A$3&'Two Sided Top Open'!$B$2:$B$3,0))

Even after pressing ctrl, shift, enter, I get a N/A value. Do you guys know how I can resolve this? Should I be using Vlookup instead?

I have attached the document that I am trying to fix. The problem is under the calculation worksheet. Any help would be much appreciated!

Thanks for the reply FDibbins! The reason for the multiple sheets is becuase I am testing out how to do this equation before doing in on all our other products which are on 50 different sheets. Is there any other way to compute it, without combining it all on one sheet?

Wow thanks! I will definatelu give this a try, and I think I am going to put them all on the same worksheet, simply because it would be less messy. Thanks for all your help!