Hello all,

I have a workbook that contains the following:

A.) (12) Spreadsheets (1) for each month (I.E. Jan. - Dec.) each of
these spreadsheets contain information regarding:

Sales Date, Company Branch / Location, Sales Rep, Customer, Sell
Price, delivery date, item being ordered, etc.

B.) (1) Main spreadsheet that stores data from all (12) monthly sheet
and runs various calculations on that data.

I want to be able to enter data in to each of the (12) monthly sheets
and then have certain pieces of data carried over / populated into the
main spreadsheet on individual rows.

What is the best way to accomplish this, that will not restrict the
addition / subtraction of data, and can be used by all sheets??? I am
currently manually enter the data into both the monthly and main
sheet.

Any assistance will be greatly appreciated. Thank you in advance.