Generating Report for multiple Inputs

[kundanlal]

Dear Sir,

Require one help.

I have a report, in attached file which is generated for code N-5. I need to generate this report for multiple codes say for code N-3,N-7,N-8,N-9 etc.

Basically, this report is generated by fetching and consolidating data from different files for that particular month and for that particular code. In this case it is N-5 which is present in cell no. B1. i.e. if I change cell B1 as N-7, the report for N-7 will appear.

As such, the report is being generated after having an input at cell B1. Instead, can it be generated sequentially in order of code present in different sheet (in this file like cell j2 to j7).

Want help to generate such report for multiple codes one below other in 2nd sheet we can call this sheet as output.

Kind Regards,

Kundanlal