Actual i add data daily to the master file.

Hence needed a pivot table so that whenever i refresh it it will give the data.