Hello all,

I need to know if there is a way to make a macro that on key press, we will say Alt+L, it will add a row to the bottom of a table and insert data from the new sheet into my master table.

Example:

I have 100 rows of information taken from 100 sheets.

I want to add a new sheet, make row 101, and duplicate a sheet, then pull information off into the main sheet.

This would allow me to add inventory faster, while being able to have individual sheets.

I know it may seem odd, but it will be very crucial and extremely helpful to me.

Thank you all in advance.