Data validation that controls which pivot table populates a worksheet

[muhleebbin]

I have a workbook for our company credit cards and what i'm trying to accomplish is to create one workbook (rather than 3 different ones) where a data validation on sheet7 would dictate which of the three pivottables would populate the columns on sheet7.

Each pivot has their own sheet currently but could be moved to a single sheet if that's easier. Most of the data on sheet7 would be populated based on the raw data that's on separate sheets for each credit card but several columns are populated based off the pivots.

Columns are shown below and columns A-J would be either blank or filled from raw data whereas columns K-N are filled from the respective pivot.

Type Location Vendor Number Date Gl Date Amount Payment Terms Due Date Comment Detail Account Detail Amount Detail Location Detail Comment

Thanks in advance for your assistance!