there is a gui option to do this, if you are comfortable with that:
https://www.tomshardware.com/how-to/raspberry-pi-access-point
from there, you'd do routing to your pc. Just plug your pi into your lan network, set ipv4 forwarding to on (in /etc/sysctl.conf uncomment the net.ipv4.ip_forward=1)
and it SHOULD rout you automatically, via the default gateway of your lan, to whatever ip you specify.
This uses the Pi's antenna, if you want more range you may wanna think about adding a different antenna via usb, or even using a real apn.
At that point you could do something more like this though:
https://www.youtube.com/watch?v=_pBf2hGqXL8
or this:
https://youtu.be/jlHWnKVpygw?si=SLVh-C3M2cABkU2S