Find, replace, add, delete data from UI?

Here's what I'm trying to do:

Forecast profit and losses, depending on new projects acquired and schedules of income and expenses associated with each project.

Here's how I'm trying to do it:

I have created a user-interface on my first page of excel. Here, a user can input the data without needing to open the database worksheet (and it's more user-friendly with little calculations to help them estimate what dates to connect to income or expenses).

I understand all the math-related aspects of the program already, it's mostly just algebra 1 or pre-algebra really. It's not the math I'm having problems with.

My problem/s:

1) The number of dates associated with income and expenses is variable. How do I copy all of the lines from the user interface into the next worksheet for data storage without copying any empty lines? (eg, user only needs 3 dates, but max is 8, if I copy the whole block and insert (with a macro), there will be 5 blank lines on the data storage worksheet).

2) I can retrieve data using the interface by doing a filter macro that will copy all relevant data from the data storage sheet back into the user interface page. However, how do I allow the user to change/delete/modify/add to that particular set of data while ensuring all the old data has been erased or changed appropriately? (deleting all of it in the data storage would probably be easiest, but how can I do that as a macro when the user hits the button to "Save new changes").. Also, I can identify a particular set of data by the project's name that will be tagged to each individual expense/ income (it's how I can filter and retrieve a particular project's income and expenses).

I know I could accomplish the functionality of the program without the user interface involved. The only reason I want the interface is that the program will become a little complicated and will be used by other people who won't know that much about how to use excel. By creating the user interface with a bunch of macro buttons, they will be less likely to mess the data up.

Does anyone have any suggestions on how to do this? I've already created the UI, but haven't linked it yet to the data storage sheets. As such, I'm pretty flexible with suggestions.

If anyone has any ideas or suggestions, please let me know... This is basically all I'm working on at work right now (I work as a proposal writer for federal work, the high season is over for a while).

Also, I'll put the file I'm working on as an attachment for anyone to look at and give recommendations. The first page is the user interface. The following pages will store the data that is input by the users. I know that it's not really functional yet, but that's why I need some help on data transfering (see above). Thanks for any input!

(The blue sections are the user input sections - don't really worry about the other ones, they're reference / sections for functional use later on).

Bumpity bump bump bump

What rhymes with Rump?... BUMP!

1) So what is it that you want to copy?
2) Are you basically trying to give people a form-type interface to a database? You could use a database - Access works pretty well for this kind of thing

You're not getting much response because it's not clear what you're asking for.

It's obvious to you what you're doing but not to others so perhaps try explaining it from a different viewpoint?

HTH