Spurs go into the game at Carrow Road on the back of a disappointing defeat in their 1-0 Europa League round-of-32 first leg against Dnipro but with a fantastic win away at Newcastle also still fresh in their minds.
A 4-0 success at St James' Park keeps Sherwood's side firmly in the hunt for a fourth-placed finish but the former Norwich midfielder feels Spurs will come up against a different proposition in Norfolk.
"Everyone chooses a different way to play," he said.
"Norwich are desperate for points. They might not come out and be expansive against us but we have to approach every game differently.
"Newcastle in our last away performance was a bit different. Newcastle came out with their expectant crowd up there and tried to play against us. We might come up against a different type but we are not sure yet, we will have to wait and see."
While Tottenham are only three points behind Liverpool in the final Champions League position, Norwich are clear of the bottom three by just a single point with manager Chris Hughton's job under threat.
But Sherwood is wary of the Canaries' ability to shock some of the league's biggest sides in front of their home fans.
"They have taken some big scalps at Carrow Road and done very well," he added.
"I think it is important we respect what they have got.
"We are expecting a tough game. They have made some signings and have got some good players. Hopefully we can second guess their team and get ourselves prepared."
The Europa League loss in Ukraine came with a side showing six changes from the Newcastle game as first-team regulars such as Hugo Lloris, Kyle Walker, Aaron Lennon and Emmanuel Adebayor did not make the trip due to niggling injuries.
Sherwood remains hopeful some of those faces will be fit to return at Norwich but is not anticipating all of them will be ready to come back into his side.
"There will be a few back," he added.
"A few won't be ready. We are looking to refresh certain areas. Some areas we won't be able to but between now and then they have to recover."
Midfielder Christian Eriksen is also aware that Norwich will prioritise keeping things tight at the back over adopting a buccaneering attacking approach to the match.
"A lot of teams sit back against us and wait for the counter-attack," he said.
"We have to try to open them up and take our chances. We know in the Premier League we've scored goals recently, we're also good away from home so hopefully we'll continue that on Sunday.
"The lads are confident after Newcastle and we have to show it again on Sunday. It is important to bounce back from Dnipro and if we want to finish in the top four we have to try to win this game."