If he is offering you a handsome reward for letting him transfer a huge amount of money to a foreign country via your bank account then no - there is no Andrew Harrison and there is no Royal Scotland Bank - it is the oldest internet scam there is - just delete the email
Yes. His office is in an internet cafe in Nigeria.
No.
You are dealing with a scam artist who is most likely in West Africa.