Introducing Nuada

Hello everyone,
I am Nuada, I am new to this forum, in fact new to any forum really.
I had considered myself to be fairly proficient at Excel but after a look around at a few threads I can tell I am not even at a basic level of proficiency yet.
I am currently trying to set up an excel workbook with user form to display data returned from several different worksheets.
I have learned a lot just poking around for the last couple of days and I hope to learn more.
I have managed to set up a user form to add new rows of data to a single sheet but that is as far as I have gotten.
(don't worry this is not a query, I will post the query in the proper section after some more independent study, after all the question asked is as important as the answer given)
Hopefully some kind souls will take pity on my ignorance and guide me in the right direction(s)!

Thank you all in advance for your help and patience ( especially patience )