I want to create a pivot table in spreadsheet A based on data in a
named range in Spreadsheet B (Spreadsheet B has mulitple tabs) . So
far I have had not luck trying any of the 3 options presented to me to
get data. Can some give me some pointers or tell me it is not
possilbe.

Thanks

JDB