Hi
i am very new to working with excel and would like the experts help in creating a macro wherein i can copy data from multiple sheets into a single master sheet. However, the number of rows in each sheet is different (max 100) and has a total, and i dont want the total to be copied into the master sheet. Rather, in the master sheet after all the data is copied except the total, a final total is required.
Also please note that the individual sheets have serial numbers which i do not want to be copied into the master sheet, instead after copying the rest of the data a final serial numbering should appear in the final sheet.
The individual sheets also contain vlookup formula, which is helping me in fetching data from other workbooks and i do not want the cells which contain n/a to appear in the final sheet due to the use of formula. My search figure is account number against which account names are populated in the individual sheets, i want the macro to copy only the rows which contain these account numbers and the corresponding data in those rows to the master sheet, and not the rows which do not have account numbers but the corresponding cells show n/a due to preapplied formulas.

Please let me know at the earliest, if required i can upload the file for ur perusal.