Macro Help. Copy data from 1 workbook to another on next available
 

I have two workbooks.

One that has my data on it, and another that we use the same data on, but we
add additional information.

How do I setup a Macro so when I type information into Workbook A (multiple
worksheets), it will automatically load it on the next available line on
Workbook B (which is a single worksheet)

I am not as familiar with Macros as I am formulas but I cannot acheive the
results I need from a formula!

PLEASE HELP ME I am STUCK!!!