Google Spreadsheets Membership system

We have a small membership service. Currently we manage our member information on a series of separate Excel spreadsheets. We'd like these all integrated into a Google Spreadsheet system. This will include populating with existing member data (about 50 active and 80 non-active members) and designing inputs for new membership data. 1/ New Member Data Entry Sheet: Be able to type in the basic information (Entry Sheet – this records all the information electronically so no more paper needed) – then it gets sent to (copied to) various sheets each with specific function (ideally this can import the data from an email or webform) 2/ Mailing labels sheet (address and status = active) – these are autosorted with Active on top and others on bottom or hidden. 3/ Basic data Sheet: name, date reg, membership type, status, last payment date & amount + notes 4/ New Member processing Sheet: columns for each task + next step + notes – final column is Completed? Yes or No – autosorts No to the top of the list (so completed new memberships are sorted to the bottom (or hidden?) Note: this is basically an Admin Task Management sheet 4/ Payments Sheet (tracks payments) Payment method (usually PayPal) Annual or Quartely? Last payment date & amount Next payment date & amount (next payment data auto-generated from first payment and whether annual or quarterly) Status: Active, Cancelled, Suspended (this posts Mailing labels and basic data sheets) Alerts: some way for missed payments to be alerted and status flagged? (so the user can see whose payments need to be checked) Notes: (It would be nice to keep the payment history but we don’t need to – if you can figure out a way to do this then great.) Also if possible Auto-import data from webform/email? (from here: [login to view URL]) Print mailing labels function (mail merge label print function - based on Mailing Labels spreadsheet) Later: Use Member information as datasource to drive Online Directory like this page: [login to view URL] NOTE: existing spreadsheets and data entry sheets available on request.