Combine Invoices into master sheet

Hello all,

I am struggling mightily with writing a Macro that grabs data including customer name, id, product name, product id, amount and the date and organizes them into a master sheet.

I know i must create a nested loop, but am struggling to compile anything that works effectively. Currently, it jumps from worksheet to worksheet and only grabs the top of ordered products and ignores the others.

The end process is supposed to cycle through all three invoices individually, move the necessary fields over to the master sheet and then move to the next invoice. Currently, its skimming the top of each. The way i have approached it is one massive For loop for all invoices and more conditional statements within. What i really need is a do while, however nothing ever compiles successfully. Currently i have been using If statements within the main for loop.

I have been working at this for hours and am only ending in frustration. I have been messing with all sorts of Variables, so some will not make any sense whatsoever. I want all of these If statements out as they are noneffective.

Please Login or Register  to view this content.

Changed it around so that it reads all of and moves data correctly for the first worksheet. How do i change this code to run through invoice worksheets(w)?

Please Login or Register  to view this content.