Row Count in Table = Cell Value

Create a Dynamic Named Range, which uses the OFFSET function.

One of the arguments in the OFFSET function calls for how many rows should be included. Set this argument to reference the cell containing the number of rows to return.

Search on Dynamic Named Ranges and post back if you need more help.

If possible, I would like to have if dynamic, so if the number in the cell changes, so do the amount of rows.

This is what Dynamic Named Ranges are for - to expand and contract automatically as the dataset changes in size to accomodate new entreis and deletions. No need to manually input a number to control the number of rows unless you have some other purpose for doing so.