Macro that creates new sheet and is capable of populating new sheet with formulas

[Pedrot1811]

Hello People

I`m working in a way to control the time employees are trained but I`m trying to make the sheet more simple to use.
I`m having trouble creating a macro that is capable of creating a new worksheet and filling that worksheet with information. It is also supposed to fill other existing worksheets but I haven`t been able to get to that point.
My problem is with getting information from one sheet into the new sheet and the other existing sheets.
For some reason there is a firewall blocking me from posting with the code. I`m very sorry for the inconvenience

I also have doubst regarding how to make a macro print out a formula into the new sheet. I wanted to use a VLOOKUP formula to correlate data from my employee data base into the new sheet.
Can somebody please help?

Edit 1: I`m able to create a new sheet, name it and also copy some information. However I`m trying to find the last row and my code isn`t working on that point.

Thank you very much
Pedro Toledo

Edit 2: I`m compilling all my other replies into this post.

The Macro that creates the new sheet is the Macrobranca. Don`t worry about the macro above it. The idea was to make itso that people don`t have to create a worksheet by themselves and then fill the information in all the right spots for the other macro

Just made the code a little bit more compact and easier to understand. I still have the last row problem and the code i`m getting is 1004 for the problem. I tried fixing it by activating the sheets i wanted to take information from before taking the information, but it didn`t work. Please I need help

[Pedrot1811]

I trying to post the code but the firewall won`t let me.
I`m posting here the actual document.
Sorry for the inconvenience

Edit 1: the macro that creates the new sheet and fills it is the MacroBranca()

[Pedrot1811]

Don`t worry about the other macro above the MacroBranca.
The reason for MacroBranca is so that people don`t have to create a worksheet by themselves and then fill the information in all the right spots for the other macro to read.

[Pedrot1811]

Just made the code a little bit more compact and easier to understand. I still have the last row problem and the code i`m getting is 1004 for the problem. I tried fixing it by activating the sheets i wanted to take information from before taking the information, but it didn`t work.

Edit 1: please help. I don`t know why it wouldn`t work

[Pedrot1811]

Yesss
I got it to work i don`t know how.
However I still have doubts regarding making a macro print out formulas in my new sheet and my other existing sheets
I`m uploading my file for you guys to take a look
THank you very much
If anybody could please help

[Pedrot1811]

Hey guys
I was able to print out the formulas i wanted by using R1C1 instead of normal A1
I`m posting my file for you guys if anyone wants to take a look and use the code