Input data to specific cell based on multiple dropdowns

This seems like it should be possible, but I can't figure it out.
My vision:
1) User clicks on "Enter Data" button
2) Button opens user form or hyperlinks to a hidden worksheet
3) User selects choice from a dropdown narrowing selection to a range of rows
4) User selects choice from a second dropdown further narrowing selection to 2 rows
5) User selects choice from a third dropdown further narrowing selection to one row
6) User selects choice from a fourth dropdown which defines the column and thus the specific cell
7) User enters data into a textbox which is then added to the cell defined by the previous dropdown selections

I have it designed, but can't figure out the programming. I'm pretty new to VBA and am trying to learn as I go, but I am stumped. Probably not the easiest first project, but it is what it is.

First, can Excel do this or would something else work better? Any help would be appreciated.