Refreshing Bearing Token

1. I already have the authentication. I did that in a seperate Query because it requires connecting to a different endpoint of the same API then the endpoint I'm pulling the data from. What I'm trying to figure out is how to get that token into the authentication of other queries. Seems like it should be simple because I have the information from the authorization in a table. I *think* I should be able to just say something like "Authorization = Name of the field the token is in"

2. I'm doing this in Excel and will be pulling the data from Excel into another program. It will not be a continuous run but I planned on using the "Refresh Query" property. The token expires every 2-3 days.