How can I create a pivot table from multiple data sources

I am trying to create a pivot table for sales to compare sales forecast against actual from various export markets.  The data comes from two sources.  In the past I have hard coded a table using lookup functions, etc. but when a new country comes along it requires new coding.  Instinctively, I feel a pivot table would be the way to go but can't get to accept data from more than one range of cells.