First off, i'm not too familiar with alot of functions and commands within
Excel yet, so if anybody has help, i'd appreciate it if you talked to me like
i was a complete idiot!

Every month i extract data from MS Great Plains into an excel spreadsheet.
The data is a list of customers (Column A - about 740 of them) and the
amounts of our materials that they use every month (Columns B, C, D, etc. -
only 1 item number, so this column is strictly quantities of that item). From
month to month, the list of customers is going to vary slightly based on if a
new customer is added, or previous customers drop out. When this happens,
i've been manually inserting blank rows so that the data in a single row is
always going to be the quantity that a single customer orders each month. As
the list is 740 customers long, it is a pain in the ass to sort through it
manually and match the new data from a current month to the rows where that
customer already has data from previous months. There must be some function
or filter that can do this for me each month. the list is sorted
alphabetically by customer, and when a new customer is added they must be
sorted alphabetically too which is why i've been inserting blank rows.

If anybody would like an example of the sheet i would be happy to supply
one. Thank you in advance for any help on this.