filter or pivot style by formula

[arctushar]

Hi
I have attached an excel file. Here "Specification" is the main data entry sheet. Now I want that in temporary sheet of the attached file Store Report Buildtrade.xlsx . I will input only the Challan number in green background cell. The date of of the challan will be automatically, I can do that. But I want that
Automatically it will pull data from specification sheet that challan number is as my givven challan number on sheet temporary. for example here I have input challan number 27009, and corresponding values r below. How can I do that ?
thanks